abstract:select concat_wa(':','id','name') as 'user_info' from 'user' where 'status'=1 order by 'age';select 查询 concat_wa(
select concat_wa(':','id','name') as 'user_info' from 'user' where 'status'=1 order by 'age';
select 查询
concat_wa(':','id','name') 以:拼接id和name列
as 起别名
from 哪个表
where 条件
order by 正序排序
update 更新
delete 删除
insert 插入
count(*) 统计
alter 修改表头
Correcting teacher:韦小宝Correction time:2018-12-15 17:25:33
Teacher's summary:总结的不错!但是课后记得多练习几遍才可以!