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
