SHOW CREATE TABLE tableName\G : Show « Command MySQL « SQL / MySQL

1. SQL / MySQL
2. Command MySQL
3. Show

SHOW CREATE TABLE tableName\G

        
mysql>
mysql> CREATE TABLE mytbl
    -> (
    ->     i INT,
    ->     c CHAR(1)
    -> );
Query OK, 0 rows affected (0.01 sec)

mysql>
mysql> SHOW CREATE TABLE mytbl\G
*************************** 1. row ***************************
       Table: mytbl
Create Table: CREATE TABLE `mytbl` (
  `i` int(11) DEFAULT NULL,
  `c` char(1) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1
1 row in set (0.00 sec)

mysql>
mysql> drop table mytbl;
Query OK, 0 rows affected (0.00 sec)

mysql>

   
    
    
    
    
    
    
    
  

Related examples in the same category