-- 创建表CREATE TABLE zhangwu11 (id INT PRIMARY KEY AUTO_INCREMENT, -- 账务IDzname VARCHAR(200), -- 账务名称zmoney DOUBLE -- 金额);RENAME TABLE zhangwu11 TO zhangwu -- 修改表名-- 插入表记录：INSERT INTO zhangwu(id, zname, zmoney) VALUES (1,'吃饭支出',247);INSERT INTO zhangwu(id, zname, zmoney) VALUES (2,'工资收入',12345);INSERT INTO zhangwu(id, zname, zmoney) VALUES (3,'服装支出',1000);INSERT INTO zhangwu(id, zname, zmoney) VALUES (4,'吃饭支出',325);INSERT INTO zhangwu(id, zname, zmoney) VALUES (5,'股票收入',8000);INSERT INTO zhangwu(id, zname, zmoney) VALUES (6,'打麻将支出',8000);INSERT INTO zhangwu(id, zname, zmoney) VALUES (7,NULL,5000);SELECT id,zname FROM zhangwu;-- 查询指定字段信息UPDATE zhangwu SET zname='吃饭支出' ,zmoney=100 WHERE id=1; -- 更新表记录INSERT INTO zhangwu VALUES (11,'上学支出',7000); -- 向表中插入所有列INSERT INTO zhangwu (zname,zmoney) VALUES ('上学支出',7000);-- -- 向表中插入某些列SELECT * FROM zhangwu -- 查询所有数据SELECT zname,zmoney FROM zhangwu;-- 查询指定列数据SELECT zname,zmoney AS money FROM zhangwu;-- 别名查询，使用的as关键字SELECT zname,zmoney+1000 AS money FROM zhangwu; -- 直接对列进行运算SELECT * FROM zhangwu WHERE zmoney>100; -- 条件查询SELECT * FROM zhangwu WHERE zmoney IN(100,1000); -- 条件查询SELECT * FROM zhangwu WHERE zmoney BETWEEN 100 AND 100000; -- 包含查询SELECT * FROM zhangwu WHERE zname LIKE '%支出'; -- 模糊查询SELECT * FROM zhangwu WHERE zname LIKE '吃___'; -- 匹配字符SELECT * FROM zhangwu ORDER BY zmoney ASC; -- 升序查询SELECT * FROM zhangwu ORDER BY zmoney DESC; -- 降序查询SELECT SUM(zmoney) FROM zhangwu; -- 计算数值整合SELECT COUNT(zmoney) FROM zhangwu; -- 统计不为null的行SELECT MAX(zmoney) FROM zhangwu; -- 计算最大值SELECT MIN(zmoney) FROM zhangwu; -- 计算最小值SELECT AVG(zmoney) FROM zhangwu; -- 计算平均值SELECT * FROM zhangwu WHERE zmoney IS NOT NULL; -- 查询指定列 非空信息SELECT * FROM zhangwu WHERE zmoney IS NULL; -- 查询指定列 为空信息SELECT zname,SUM(zmoney) AS money FROM zhangwu -- 求zmoney总和给moneyWHERE zname IS NOT NULL -- zname不为空GROUP BY zname -- 进行分组HAVING money >1000 -- 条件查询ORDER BY money DESC -- 进行排序