Using Show Create Table command to check table : Show « Command MySQL « SQL / MySQL

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

Using Show Create Table command to check table

        
mysql>
mysql> CREATE TABLE test1 (col1 VARCHAR(20), col2 CHAR(20));
Query OK, 0 rows affected (0.01 sec)

mysql>
mysql>
mysql> SHOW CREATE TABLE test1;
+-------+---------------------------------------------------------------------------------------------------------------
------------------+
| Table | Create Table
                  |
+-------+---------------------------------------------------------------------------------------------------------------
------------------+
| test1 | CREATE TABLE `test1` (
  `col1` varchar(20) DEFAULT NULL,
  `col2` char(20) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 |
+-------+---------------------------------------------------------------------------------------------------------------
------------------+
1 row in set (0.00 sec)

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

mysql>
mysql>
mysql>

   
    
    
    
    
    
    
    
  

Related examples in the same category