From: Subba Reddy M Date: Fri, 26 Jan 2001 14:52:29 +0530 Hello MySQL guru, Please advise me, on creating new table with existing table structure. I have tried, how MySQL documentation referred, but unable to get success. create table newtable select * from oldtable; This works on 3.23.x check doc for version. --------------------------------------------------------------------- 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