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! Quote 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 Quote 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--] Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.