Dexter wrote: >Just want to copy the table structure of a table i Have but dont have the >the create statement and dont want to have to type it again , it has a lot >of fields. Can I easily replicate a table.
or: >SHOW CREATE TABLE table_name; will show the SQL necessary to recreate a table. -ravi. -----Original Message----- From: Robert Cross [mailto:[EMAIL PROTECTED]] Sent: October 22, 2001 10:07 AM To: Dexter Coelho Cc: [EMAIL PROTECTED] Subject: Re: How to copy table structure easily. --------------------------------------------------------------------- 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