MySQL ~MySQL的常用命令(懒人必备)

创建表

CREATE TABLE IF NOT EXISTS `mysql-study`.`student`  (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '学号',
  `name` varchar(30) NOT NULL DEFAULT '匿名' COMMENT '姓名',
  `sex` varchar(2) NOT NULL DEFAULT '隐藏' COMMENT '性别',
  `pwd` varchar(20) NOT NULL DEFAULT '123456' COMMENT '密码',
  `birthday` datetime NULL DEFAULT NULL COMMENT '出生日期',
  `address` varchar(100) NULL DEFAULT NULL COMMENT '家庭住址',
  `email` varchar(50) NULL DEFAULT NULL COMMENT '邮箱',
  PRIMARY KEY (`id`)
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '创建学生表模板'

---

查看创建数据库的SQL语句

-- 查看创建数据库的SQL语句
SHOW CREATE DATABASE `mysql-study`;
-- CREATE DATABASE `mysql-study` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_bin */ /*!80016 DEFAULT ENCRYPTION='N' */

查看创建student表的SQL语句

-- 查看创建student表的SQL语句
SHOW CREATE TABLE `mysql-study`.student;
/*
	CREATE TABLE `student` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '学号',
  `name` varchar(30) COLLATE utf8mb4_bin NOT NULL DEFAULT '匿名' COMMENT '姓名',
  `sex` varchar(2) COLLATE utf8mb4_bin NOT NULL DEFAULT '隐藏' COMMENT '性别',
  `pwd` varchar(20) COLLATE utf8mb4_bin NOT NULL DEFAULT '123456' COMMENT '密码',
  `birthday` datetime DEFAULT NULL COMMENT '出生日期',
  `address` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '家庭住址',
  `email` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '邮箱',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='创建学生表模板'
*/

显示表的结构

-- 显示表的结构
DESC `mysql-study`.student;