CREATE TABLE `student` (
`id` int NOT NULL AUTO_INCREMENT COMMENT '学号',
`pwd` varchar(32) NOT NULL DEFAULT '123456' COMMENT '密码',
`name` varchar(32) NOT NULL COMMENT '名字',
`address` varchar(60) NOT NULL COMMENT '地址',
`email` varchar(100) DEFAULT NULL COMMENT '邮箱',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3
SHOW CREATE TABLE student
定义表的语句
CREATE DATABASE `school` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */ /*!80016 DEFAULT ENCRYPTION='N' */
SHOW CREATE DATABASE school
定义数据库的语句
DESC student
查看结构