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;
vBulletin® v3.8.12 by vBS, Copyright ©2000-2024, vBulletin Solutions Inc.