phpMyAdmin and SHOW CREATE TABLE

phpmyadmin shortcut create-table
waiwai933 picture waiwai933 · Jun 22, 2010 · Viewed 19k times · Source

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.

Answer

Mohd Abdul Mujib picture Mohd Abdul Mujib · Jan 1, 2016

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.

  • There is this Hyperlink named +Options right above the truncated SQL that you are getting, Clicking on which shall make make a few toggles/options appear.
  • There select Full Texts, And right below this toggle there is this Go button, maybe on the extreme right.
  • And You should get the Full Text of the SQL.

Related questions

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

I installed LAMP on Ubuntu 12.04 LTS (Precise Pangolin) and then set root password on phpMyAdmin. I forgot the password and now I am unable to login. When I try to change password through terminal I get: ERROR 2002 (HY000): Can't connect …

Read More
PHPMyAdmin Default login password

I have done a fresh installation of Fedora 14 and installed the phpMyAdmin module. When I run phpMyAdmin, it asks me for a username and password. What is the default username and password for phpMyAdmin?

Read More
Import file size limit in PHPMyAdmin

I have changed all the php.ini parameters I know: upload_max_filesize, post_max_size. Why am I still seeing 2MB? Im using Zend Server CE, on a Ubuntu VirtualBox over a Windows 7 host.

Read More