mysql怎么查看自己建的表_MySQL查看表结构及查看建表语句

mysql> show create table user;

+-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

| Table | Create Table |

+-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

| user | CREATE TABLE `user` (

`id` bigint(20) NOT NULL,

`username` varchar(20) NOT NULL,

`password` varchar(20) NOT NULL,

`hometown` varchar(20) DEFAULT NULL,

`gender` varchar(20) DEFAULT NULL,

`birthday` varchar(20) DEFAULT NULL,

`email` varchar(20) DEFAULT NULL,

`phone_number` varchar(20) DEFAULT NULL,

`profession` varchar(20) DEFAULT NULL,

`hobby` varchar(100) DEFAULT NULL,

PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 |

+-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

1 row in set (0.00 sec)