查看数据库

SHOW DATABASES

创建数据库

CREATE DATABASE shops;

打开数据库

USE shops

创建数据表

CREATE TABLE books(

id INT(30) PRIMARY KEY,

nam VARCHAR(100) NOT NULL,

TYPE VARCHAR(50),

price DECIMAL(7,2),

num INT(11),

TIME DATETIME

);

插入数据

INSERT INTO books(id,TYPE,nam,price,num,TIME)

VALUES(1,'书籍','西游记',50.4,20,'2018-01-01 13:40:40'),

(2,'糖类','牛奶糖',50.4,20,'2018-02-02 13:40:40'),

(3,'糖类','水果糖',7.4,200,NULL),

(4,'服饰','休闲西服',800.00,NULL,'2018-02-02 13:40:40'),

(5,'饮品','果汁',3.0,70,'2018-02-02 13:40:40');

更新数据

UPDATE books SET num=196 WHERE nam='水果糖';

删除数据

DELETE FROM books WHERE id=2;

查看表结构，点击表数据

DESCRIBE books;