RE: Moving Data between Tables

2007-05-31 Thread Kebbel, John
"I hope you're not about to try this for the first time on your production data :-) " I dumped the lockers table before beginning my experiments. If I had trashed lockers2 (my experimental file) in the process, I would have truncated it and re-inserted the 1492 records from my batch file.

Re: Moving Data between Tables

2007-05-31 Thread Baron Schwartz
Hi John, Kebbel, John wrote: I moved information about our school locks (serial numbers, combinations, student, etc) from FileMaker to MySQL into a table called lockers and wrote PHP pages so our teachers could record the locks returned at the end of the year. Unfortunately, I missed transfer

Moving Data between Tables

2007-05-31 Thread Kebbel, John
I moved information about our school locks (serial numbers, combinations, student, etc) from FileMaker to MySQL into a table called lockers and wrote PHP pages so our teachers could record the locks returned at the end of the year. Unfortunately, I missed transferring close to 200 locks. I dup