Re: mysql problem more than php

I'm not sure about any function but you can try this on the prompt: (structure only) CREATE TABLE mycopy SELECT * FROM originaltable WHERE 1=2 (with data) CREATE TABLE mycopy SELECT * FROM originaltable Should work... - E

I want to copy all the contents of one table into another table is there a function to do all this automatically create table, fields and copy the data

across if given only a new tabe name. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

_________________________________________________________________ かわいくて愉快なイラスト満載 MSN キャラクター http://character.msn.co.jp/