关系数据库基本操作

-- 查询   查询=selsect
SELECT * FROM t_user03 WHERE id = 1
SELECT * FROM t_user03 WHERE NAME = '张三'
SELECT * FROM t_user03 WHERE height = 170
-- 修改	  修改=update   设置=set
UPDATE t_user03 SET NAME = '李四2' WHERE id = 1;
UPDATE t_user03 SET NAME ='李四3' WHERE age = 24
-- 插入   插入=tnsert
INSERT t_user03(NAME,age,height) VALUES('娟姐',24,170);
-- 删除   删除=delete	和=and
DELETE FROM t_user03 WHERE id = 5;
DELETE FROM t_user03 WHERE NAME = '娟姐'
DELETE FROM t_user03 WHERE age = 24 AND NAME = '王二'
-- 查询总条数   count = 计数
SELECT COUNT(*) AS '总数' FROM t_user03 WHERE age = 22;
--                           sum=总和             AVG=平均   GROUP 分组   BY=通过
SELECT *,COUNT(*) '每组人数',SUM(age) '每组总年龄',AVG(height) '每组平均身高' FROM t_user03 GROUP BY height;
-- 蠕虫复制`t_user03`
INSERT INTO t_user03(NAME,age,height) SELECT NAME,age,height FROM t_us