{rendie:strip}
SQL高级助手 | |
SQL帮助
![]() |
|
1: | 列出所有数据 select * from {pre}video |
2: | 删除所有数据 delete from {pre}video |
3: | 列出某一栏目数据 select * from {pre}video where {pre}type =(select {pre}id from {pre}type where {pre}name = '动作片') |
4: | 删除某一栏目数据 delete from {pre}video where {pre}type =(select {pre}id from {pre}type where {pre}name = '动作片') |
5: | 列出某一专题的数据 select * from {pre}video where {pre}type =(select {pre}id from {pre}topic where {pre}name = '男人必看十部电影') |
6: | 删除 某一专题的数据 delete from {pre}video where {pre}type =(select {pre}id from {pre}topic where {pre}name = '男人必看十部电影') |
7: | 插入一部影片到数据库中 insert into {pre}video ({pre}name,{pre}des) values ('你好中国','这里是剧情简介') |
8: | 更新 update {pre}type set {pre}type=1 where {pre}type=0 |
9: | 我们要删除 全部的综艺片,但是好多数据!得一页一页的删!好慢,我们用sql助手! 但是我们不知道综艺片的ID啊,那就先来一句查询select {pre}id,{pre}name from {pre}type where {pre}name like '%综艺片%' |
10: | 查找简介中包含"你好"的影片! SELECT {pre}name FROM {pre}video WHERE {pre}des LIKE '%你好%' |
11: | 表达格式:SELECT "栏位名" FROM "表格名" 比如我们要查找所有分类的名称 select {pre}id,{pre}name from {pre}type 我们看到了查询多个栏目【这里是ID,和name】用逗号,隔开! |
12: | SELECT "栏位名" FROM "表格名" WHERE "条件" 比如我们筛选出data表中ID大于7000的数据的片名:select {pre}name from {pre}video where {pre}id>7000 SELECT {pre}name FROM {pre}video WHERE {pre}id > 1000 and {pre}id < 2000 多个条件可以用【and和】或者【or或】连接 |
13: |
SELECT "栏位名" FROM "表格名" WHERE "栏位名" LIKE {套式} 这么说就有点复杂了,我举几个我们能用到的套式!我们要查找简介中包含"你好"的影片! SELECT {pre}name FROM {pre}video WHERE {pre}des LIKE '%你好%' 这样简介中包含你好的就都出来了,编辑一下就可以了! 这个常用语虚拟主机安装一流信息检测系统不允许的词汇的时候用! |
14: |
INSERT INTO "表格名" ("栏位1", "栏位2", ...)VALUES ("值1", "值2", ...) 比如我们要查找所有分类的名称 select {pre}id,{pre}name from {pre}type 我们看到了查询多个栏目【这里是ID,和name】用逗号,隔开! |
15: | update {pre}video set {pre}publisharea=Left({pre}publisharea,INSTR({pre}publisharea,' ')-1) where INSTR({pre}publisharea,' ')>0 |
16: | select * from {pre}video WHERE {pre}cntype LIKE '%'&{pre}publisharea&'%' |
17: | SELECT * FROM {pre}video where INSTR({pre}cntype,{pre}publisharea&',')>0 |
18: | update {pre}video set {pre}cntype=Mid({pre}cntype,INSTR({pre}cntype,',')+1) where INSTR({pre}cntype,{pre}publisharea&',')>0 |
19: | update {pre}video set {pre}cntype=Mid({pre}cntype,1) where left({pre}cntype,1)=',' |
20: | select * from {pre}video WHERE {pre}playdata LIKE '%qvod$$%' and {pre}type<>4 |
21: | 将字段中的"、"替换为"|"; (1)SELECT left({pre}title,INSTR({pre}title,'、')-1)&'|'&mid({pre}title,INSTR({pre}title,'、')+1) FROM {pre}product where INSTR({pre}title,'、')>0 (2)update {pre}product set {pre}title=left({pre}title,INSTR({pre}title,'、')-1)&'|'&mid({pre}title,INSTR({pre}title,'、')+1) where INSTR({pre}title,'、')>0 |
提示:更多sql语句应用教程 | |
执行SQL语句结果
![]() |
|