Quote:
Originally Posted by alexg
I tried to edit the mysql tables, but it only allows me to copy a table to another table in the same mysql database. I want to copy to a different database. is that possible?
|
insert into newdatabasename.tablename(fieldlist) select fieldlist from olddatabasename.tablename
Where fieldlist is the lsit of fields you are pulling from one database/table into the other database/table