dabingsun的博客

别名 SELECT column_name AS alias_name FROM table_name; 列名别名 SELECT column_name FROM table_name AS alias_name; 表名别名 多表连接（join） select * from tbl_1 as b1 inner join tbl_2 as b2 on b1.id = b2...

目录 增删改查 where：条件 order by：排序 菜鸟教程 tbl_score表： 增删改查 查： select * from tbl_score where id = 2 删： delete from tbl_score where id = 2 改： update tbl_score set score1= 33, score2 = 32 where ...