PHP DB - MySQL data harvester

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

MySQL data harvester

Matthew Perry

2004-11-02, 3:55 pm

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

Sponsored Links