MySQL data harvester

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



My office purchased 21 fascinating cell phones that have GPS locaters and
bar codes.  

 

When we scan a bar code with one of these cell phones, the data is sent to a
third party company; information about this scan is stored on their
database.  

I have installed a "harvester" on my pc that downloads this data off of the
third party database into my own MySQL database.

I want to link this data with my other tables to modify my inventory
information.

 

What is the best way to continuously update all tables when new transactions
occur?  With MS SQL Server or ORACLE I would write a stored procedure or
trigger that could do this.  

What tools can I use with MySQL instead of procedures or triggers?

 

Matthew


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux