PDA

View Full Version : Copying Tables from 1 db to another?


obiwan8472
06-11-2003, 06:45 PM
I need to copy 1 table to another database. But work out the SQL for it.
I use phpmyadmin thing.
thanx

filburt1
06-11-2003, 07:22 PM
Either:
1. Download it via PMA's built-in methods and reupload it.
or
2. (untested):

INSERT INTO database2.tablename SELECT * FROM database1.tablename;