Greetings... It is possible. Say for eg. If you want to copy the structure and data of the db table in mysql table. you can use the following statement -
create table `db_copy` ( primary key ( Host, Db, User ) ) select * from `db` If you cant to copy only the structure then you can use a query like this - create table `db_copy` ( primary key ( Host, Db, User ) ) select * from `db` where 1 = 0 Hope It helps Insane http://www.webyog.com/sqlyog The definative GUI client for MySQL ----- Original Message ----- From: "Shaun Bramley" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, September 28, 2002 10:48 PM Subject: Copying a Table > Hello all, > > I have yet to find this bit of information within the documentation. Is it > possible to copy the contents of a table? If so how? > > Shaun > mysql, query > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php