How to generate a create table script for an existing table in phpmyadmin

Question

How can I generate a create table script for an existing table in phpmyadmin

User · Answer

Query information schema columns directly   select   from information schema columns  where table name    your table  and table schema    your database

User · Answer

Run query is sql tab     SHOW CREATE TABLE tableName   Click on       Options -  Choose Full texts -  Click on Go   Copy Create Table query and paste where you want to create new table

User · Answer

Right click on table name-- gt choose open table -- gt  Go to Info Tab and the scroll down to see create table script

User · Answer

Run SHOW CREATE TABLE  lt table name gt  query

User · Answer

Use the following query in sql tab   SHOW CREATE TABLE tablename   To view full query There is this Hyperlink named  Options left above  There select Full Texts

User · Answer

Using PHP Function   Of course query function   this- model  you have to change to your own          Creating a copy table based on the current one         param type  table to copy     param type  new table name     return type     throws Exception     public function create  table to copy   new table name         sql    SHOW CREATE TABLE    table to copy        res    this- gt model- gt queryRow  sql  PDO  FETCH ASSOC        if  filled  res  Create Table             throw new Exception  Could not get the create code for    table to copy         newCreateSql   preg replace array            CREATE TABLE     table to copy                 KEY     table to copy                      CONSTRAINT     table to copy                      AUTO INCREMENT                  array           CREATE TABLE     new table name               KEY     new table name   1             CONSTRAINT     new table name   1             AUTO INCREMENT 1            res  Create Table          return  this- gt model- gt exec  newCreateSql

User · Answer

This may be a late reply  But it may help others  It is very simple in MY SQL Workbench   I am using Workbench version 6 3 and My SQL Version 5 1 Community edition   Right click on the table for which you want the create script  select  Copy to Clipboard --  Create Statement  option  Simply paste in any text editor you want to get the create script

User · Answer

SHOW CREATE TABLE your table name   gt  Press GO button  After show table  above the table    options   Hyperlink is there   Press   options  Hyperlink then appear some options select  Full texts    gt  Press GO button

User · Answer

Export whole database select format as SQL  Now  open that SQL file which you have downloaded using notepad  notepad   or any editor  You will see all the tables and insert queries of your database  All scripts will be available there

User · Answer

Use the following query in sql tab  SHOW CREATE TABLE your table name Press GO button After show table  above the table    options   Hyperlink  Press  options Hyperlink then appear some options select  Full texts  press GO button  Show sql quaery

User · Answer

Mysqladmin can do the job of saving out the create table script   Step 1  create a table  insert some rows   create table penguins  id int primary key  myval varchar 50   insert into penguins values 2   werrhhrrhrh   insert into penguins values 25   weeehehehehe   select   from penguins   Step 2  use mysql dump command   mysqldump --no-data --skip-comments --host your database hostname or ip com -u your username --password your password your database name penguins  gt  penguins sql   Step 3  observe the output in penguins sql      40101 SET  OLD CHARACTER SET CLIENT   CHARACTER SET CLIENT        40101 SET  OLD CHARACTER SET RESULTS   CHARACTER SET RESULTS        40101 SET  OLD COLLATION CONNECTION   COLLATION CONNECTION        40101 SET NAMES utf8        40103 SET  OLD TIME ZONE   TIME ZONE        40103 SET TIME ZONE   00 00         40014 SET  OLD UNIQUE CHECKS   UNIQUE CHECKS  UNIQUE CHECKS 0        40014 SET  OLD FOREIGN KEY CHECKS   FOREIGN KEY CHECKS  FOREIGN KEY CHECKS 0        40101 SET  OLD SQL MODE   SQL MODE  SQL MODE  NO AUTO VALUE ON ZERO         40111 SET  OLD SQL NOTES   SQL NOTES  SQL NOTES 0     DROP TABLE IF EXISTS  penguins      40101 SET  saved cs client         character set client        40101 SET character set client   utf8     CREATE TABLE  penguins       id  int 11  NOT NULL     myval  varchar 50  DEFAULT NULL    PRIMARY KEY   id     ENGINE InnoDB DEFAULT CHARSET latin1     40101 SET character set client    saved cs client        40103 SET TIME ZONE  OLD TIME ZONE         40101 SET SQL MODE  OLD SQL MODE        40014 SET FOREIGN KEY CHECKS  OLD FOREIGN KEY CHECKS        40014 SET UNIQUE CHECKS  OLD UNIQUE CHECKS        40101 SET CHARACTER SET CLIENT  OLD CHARACTER SET CLIENT        40101 SET CHARACTER SET RESULTS  OLD CHARACTER SET RESULTS        40101 SET COLLATION CONNECTION  OLD COLLATION CONNECTION        40111 SET SQL NOTES  OLD SQL NOTES       The output is cluttered by a number of executional-condition tokens above and below   You can filter them out if you don t want them in the next step   Step 4  Optional   filter out those extra executional-condition tokens this way   mysqldump --no-data --skip-comments --compact --host your database hostname or ip com -u your username --password your password your database name penguins  gt  penguins sql   Which produces final output   eric dev  home el   cat penguins sql  DROP TABLE IF EXISTS  penguins   CREATE TABLE  penguins       id  int 11  NOT NULL     myval  varchar 50  DEFAULT NULL    PRIMARY KEY   id     ENGINE InnoDB DEFAULT CHARSET latin1

User · Answer

One more way  Select the target table in the left panel in phpMyAdmin  click on Export tab  unselect Data block and click on Go button

User · Answer

I found another way to export table in sql file   Suppose my table is abs item variations  abs item variations - gt structure - gt  propose table structure - gt  export - gt  Go

[mysql] How to generate a create table script for an existing table in phpmyadmin?

Query information_schema.columns directly:

Examples related to mysql

Examples related to phpmyadmin