m.sql

DROP DATABASE if exists Books;
CREATE DATABASE Books;
use Books;
DROP TABLE if exists books;
CREATE TABLE books
(
    `Bid` int(10) NOT NULL,
    `Bname` varchar(100) NOT NULL,
    `Bnumber` int(10) NOT NULL,
    PRIMARY KEY (`Bid`)
)ENGINE=InnoDB CHARSET=utf8;
INSERT INTO books VALUES 
(1, '机器学习', 80), (2, 'J2EE 从入门到精通', 14), (3, '数据结构与算法', 22), (4, 'Java 网络编程设计实训', 45), (5, 'Javascript 高级编程', 233),
(6, '算法导论', 32), (7, 'C++11 标准库', 182), (8, '高性能 MySQL', 12), (9, 'Linux 服务器架设与维护', 76), (10, '系统架构设计师入门', 66),
(11, 'BootstrapTable 教程', 52), (12, 'Kotlin 入门教程', 182), (13, 'Flutter 实战', 712), (14, '精通 Linux', 476), (15, '流程的 Python', 606),
(16, '设计模式 (JAVA版)', 362), (17, '深度学习', 1282), (18, 'Redis 开发与运维', 127), (19, 'Nginx_Lua 高性能实践', 376), (20, 'SpringBoot 入门', 76);
SELECT * FROM books;