> 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.
Hi Dexter, I took a look at a number of the MySQL management tools as mentioned in articles/discussions on various MySQL-interest web sites. Currently I am using one called MySQL-Front (www.MySQLFront.de) which I believe works on a variety of OpSys/platforms. I find that I rarely need to drop into 'native' MySQL these days (which may not be the best thing for my SQL DDL skills, but...). Amongst other things, this tool allows the exporting of tables - either the structure, or the data, or both. These are exported as a *.sql file, all ready to be piped straight back into 'native' MySQL, or using MySQL-Front, brought back into its editing window - where a quick change to the table name, etc, followed by in-tool SQL code execution will produce a clone. Brilliant stuff! Regards, =dn BTW did we solve your previous problem? --------------------------------------------------------------------- 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
