-- 创建一张学生表,如果student存在则不创建
-- CREATE TABLE IF NOT EXISTS student(
-- id INT PRIMARY KEY NOT NULL auto_increment,
-- name VARCHAR(20) NOT NULL DEFAULT('') COMMENT '姓名',
-- age TINYINT UNSIGNED NOT NULL DEFAULT(0) COMMENT '年龄',
-- height FLOAT UNSIGNED NOT NULL DEFAULT(0) COMMENT '身高,单位cm'
-- );
-- 向student数据表插入数据
-- INSERT INTO student(name, age, height) VALUES
-- ('陈宇晨', 19, 165.3),
-- ('肖俊磊', 18, 169.5),
-- ('刘伟豪', 20, 171.2),
-- ('叶德超', 21, 175.9),
-- ('熊志洋', 18, 180.7),
-- ('胡文清', 20, 177.2),
-- ('李小勇', 19, 173.4),
-- ('唐鹏', 20, 176.8);
-- ==================事务的使用方式==================
-- SET autocommit = FALSE; # 关闭自动提交事务,需要手动开启和提交才能对数据库产生持久的影响
-- SET autocommit = TRUE; # 重新开启自动提交事务
# ===================事务操作=======================
-- START TRANSACTION; # 开启事务
-- INSERT INTO student(name, age, height) VALUE ('月都散人', 18, 180.0); # 插入数据
-- COMMIT; # 提交数据
-- ROLLBACK; # 回滚数据
#====================索引的介绍使用=================
-- ALTER TABLE student ADD INDEX index_student(id, name);
-- SHOW INDEX FROM student;
-- DROP INDEX index_student ON student;
-- SELECT name FROM student WHERE name = '月都散人' AND age = 18;