注册
登录
| 关键词： stu name class select where like type age order desc |
SQL学习 SQL1: select * from class select c_id,c_name from class select c_name,c_stu from class where c_stu>50 or c_stu<20 SQL2:模糊查询 select top 5 c_name,c_stu from class where c_stu>30 and c_type=true and c_name like '*二班*' order by c_stu asc,c_type desc SQL3:多表联合查询 select c_name,s_no,s_name from class,stu where c_id=s_cid and c_stu>20 and s_no like '?006*' order by s_no desc SQL4:增加，删除，修改 insert into class (c_name,c_stu,c_type) values ('三年二班',45,false) delete from stu where s_age>45 update stu set s_age=s_age-1 where s_no like '?6?1*' |
|
| 友情提醒：以上链接来自互联网，请注意风险！ |
|
声明：文章版权归原作者所有 部分文章转自互联网 如有侵权请联系
[邮箱地址] 删除
|
