| Table | Create Table | +---+--- ---+ | tb_common_member | CREATE TABLE `tb_common_member` ( `uid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`uid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | +---+--- ---+ 1 row in set (0.00 sec) mysql> 3、use information...
-- 1 查看建表语句DDL SHOW CREATE TABLE `sys_user`; -- SHOW CREATE VIEW sys_user_view; -- SHOW CREATE DATABASE 0_tmp; -- 2 简要查看表字段信息 DESCRIBE `sys_user`; -- DESCRIBE `sys_user_view`; -- SHOW FULL COLUMNS FROM `sys_user`; -- SHOW FULL COLUMNS FROM `sys_user_view`...
SHOW CREATE TABLE SHOW CREATE TABLE table_name; 1.
mysql show create table `tablename` 查看建表语句 2013-05-16 22:27 −... simhare 0 11775 MySQL 查看表结构简单命令 2017-05-18 16:05 −一、简单描述表结构,字段类型 desc tabl_name; 显示表结构,字段类型,主键,是否为空等属性,但不显示外键。 例如:desc table_name 二、查询表中列的注释信息...
-- 1.2.查看所有对象DDL定义语句(表、视图、函数等)showcreatetablestudent;showcreateviewstudent_view;showcreatefunctionget_stu_name;showcreateproceduremy_procedure;showcreatedatabase test;showcreatetablespace***;showcreateuserroot; 2.测试 建表、视图、索引 ...