bubberz Posted October 5, 2005 Share Posted October 5, 2005 Is there a way to get the mySQL monitor to generate the SQL script for the creation of a table? I'm kinda looking for the same thing SQL Server does to allow you to preview the SQL script for a table. Thanks! Link to comment https://forums.phpfreaks.com/topic/2616-generate-sql-script-for-table/ Share on other sites More sharing options...
marker5a Posted October 5, 2005 Share Posted October 5, 2005 If you have phpmyadmin or any mysql management software, usually there is a way to "dump" a database or a table. That will give you a printout of the actual SQL queries to make the database. Hope that helps Chris Link to comment https://forums.phpfreaks.com/topic/2616-generate-sql-script-for-table/#findComment-8673 Share on other sites More sharing options...
ryanlwh Posted October 5, 2005 Share Posted October 5, 2005 [!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--]SHOW CREATE TABLE tablename [!--sql2--][/div][!--sql3--] Link to comment https://forums.phpfreaks.com/topic/2616-generate-sql-script-for-table/#findComment-8674 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.