--- In [email protected], "Brian Boothe" <[EMAIL PROTECTED]> wrote: I have a mysql database table setup already but I need to go back and enter in a 4 digit Company Code to each of my records how can I do this automatically that starts at the First record with 0000
And automatically Increments and inserts into each of the rest of the records: ,, thanks for all your help ------------------------------------------------------------- Hi Brian I am assuming that the company code field doesn't currently exist. if it doesn't, I would recommend that you export your table using phpmyadmin (or some such), then delete the data and reinsert it using phpmyadmin. But before you do, you can change/insert the company code field to auto increment using the required 4 digits starting at 0000. Now when you import your data the company code field should be filled in automatically, starting at 0000, 0001, etc. Hope that helps. Joseph
