(一)插入数据
(1)插入完整的行
INSERT INTO 表名 VALUES('A','B','C')
INSERT INTO family VALUES('1011','2016-12-16','other','5');
(2)INSERT INTO 表名 (变量名1,变量名2,变量名3) VALUES('A','B','C')
INSERT INTO family (id,day,classification,price,remark)
VALUES('1011','2016-12-16','other','5','AA');
(3)插入多个行
INSERT INTO 表名 (变量名1,变量名2,变量名3) VALUES('A','B','C'), ('A','B','C');
INSERT INTO family (id,day,classification,price,remark) VALUES('1011','2016-12-16','other','5','AA'), ('1012','2016-12-16','other','3','BB');
(4)插入检索出的数据
INSERT INTO 表名 (变量名1,变量名2,变量名3)SELECT变量名1,变量名2,变量名3 FROM 数据库名
INSERT INTO family (id,day,classification,price,remark) SELECT id,day,classification,price,remark FROM xcy;
(二)更新数据
UPDATE 表名 SET 变量名=‘要更新的数据’ WHERE 条件(id=1001);
update family set classification='cloth' where id=1004;
(三)删除数据
DELETE FROM family WHERE id=1001;
(四)检索数据
(1)SELECT 变量名1,变量名2,变量名3
FROM 表名;
SELECT id,day,classification,price FROM family;
(2)检索所有列
SELECT *
FROM 表名;
SELECT * FROM family;
(3)检索不同的行
SELECT DISTINCT 变量名
FROM 表名;
SELECT DISTINCT id FROM family;
//返回唯一的ID行
(4)限制结果
SELECT 变量名
FROM 表名
LIMIT 数量;
SELECT id FROM family LIMIT 5;
//返回不多于5行
SELECT 变量名
FROM 表名
LIMIT 数量,数量;
SELECT id FROM family LIMIT 5,5;
//返回从行5开始的5行