Hello,
I am currently looking at moving some of my FoxPro tables to a MySQL
implementation and I am hoping someone can help me with how to do the
following.
In my current code, whenever anyone makes a change to a row the original
value of the row is written to a history table with the same name
It sounds like you are looking to do an INSERT SELECT.
http://dev.mysql.com/doc/mysql/en/insert-select.html
It allows you to insert into one table based on a select from another
table. That will take care of creating your history. You then need to
do an update on the main table. It's still a two