I need to copy some tables from one mysql database to another mysql database
on the same server.
I looked at the php manual and couldn't find it...I found stuff on
mysqlhotcopy, but it doesn't look like that will do what I need it to do, or
maybe I'm reading the manual wrong.
Can someone please s
Have you tried something like this:
insert into database1.tablename select * from database2.tablename;
database1 and database2 are the names of the two databases. tablename is
the name of the table you want to copy from database1 to database2. In
your case I guess this would be:
insert i
David Smith wrote:
insert into database1.tablename select * from database2.tablename;
database1 and database2 are the names of the two databases. tablename
is the name of the table you want to copy from database1 to database2.
Correction: from database2 to database1, not vice versa.
--Dav
Jeremy wrote:
I need to copy some tables from one mysql database to another mysql database
on the same server.
I looked at the php manual and couldn't find it...I found stuff on
mysqlhotcopy, but it doesn't look like that will do what I need it to do, or
maybe I'm reading the manual wrong.
Can som