1、创建数据库 mydb
CREATE DATABASE mydb;
2、创建表格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)
);
DESC books;
1、创建数据库 mydb
CREATE DATABASE mydb;
2、创建表格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)
);
DESC books;