1、创建数据库 mydb
2、创建表格books
# 创建数据库mydb
CREATE DATABASE mydb;
# 使用mydb数据库 用于切换
USE mydb;
# 查看当前正在使用的数据库
SELECT DATABASE();
# 创建表格books
CREATE TABLE books(
b_id INT(11),
b_name VARCHAR(50),
authors VARCHAR(100),
price FLOAT,
pubdate YEAR(),
note VARCHAR(100),
num INT(11)
);
# 插入数据
INSERT INTO books VALUES("1","《西游记》","吴承恩","69.8",null,"四大名著之一","999");
INSERT INTO books VALUES("2","《红楼梦》","曹雪芹","69.8",null,"四大名著之一","999");
INSERT INTO books VALUES("3","《水浒传》","施耐庵","69.8",null,"四大名著之一","999");
INSERT INTO books VALUES("4","《三国演义》","罗贯中","69.8",null,"四大名著之一","999");
# 删除整张表后 再创建与之前格式一样的新表
truncate table books;
# 查看数据表结构
DESC books;