inserting values into mysql table
Posted on 2006-10-28
Probably basic, but I am a novice in mysql....just able to manipulate data in phpmyadmin and run rudimentary queries.
I have two tables in two different mysql databases.
Want to move the older table values into the new one.
The new table has more field rows (89) than the old one that is populated with values (72).
Both tables have the same field names, its is just that there are new ones added to the newer version of the dbase.
Is there a way to import by matching the field names or something like that? Or how do I enter null values or deault values into the old table's data so it matches up with the number of fields in the new table? Or basically what is the best way to match these up so I can import the data to the new table?