Menu
Is there a shortcut in phpMyAdmin to SHOW CREATE TABLE for a table (i.e. a button I can click to get the full query, not the truncated one)?
Also, can I query multiple SHOW CREATE TABLEs simultaneously in phpMyAdmin? If I separate them, only the last one appears.
557
Choose the Database User and click phpMyAdmin. On the left pane of your phpMyAdmin page, click on the Database User. Click on the table to display the Structure page for the table.
SELECT create_time FROM INFORMATION_SCHEMA. TABLES WHERE table_schema = 'yourDatabaseName' AND table_name = 'yourTableName'; My table name is 'skiplasttenrecords' and database is 'test'.
In MySQL workbench, you get the already created table script, by just right click on the specific table, then select send to SQL editor>>create statement . That's all you will get the create table script on the editor.
If you are trying to export the Table Schema Using the SHOW CREATE TABLE Query Inside phpmyadmin, and are getting some truncated SQL then please follow the following steps to output the complete SQL Query to replicate the table structure.
+Options right above the truncated SQL that you are getting, Clicking on which shall make make a few toggles/options appear.Full Texts, And right below this toggle there is this Go button, maybe on the extreme right.
189
It sounds like what you want is all/part of the result of the 'export' tab.
If you tell it to export in sql, it gives you the table creation and popluation code (for all tables in the database)
33
Click the database > Select the tables you want > Choose With selected: Show create > done
Screenshots:
35
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
