{rendie:strip} 工具_SQL高级助手-RENDIE后台管理 {rendie:load 顶部.html}
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语句应用教程
{rendie:load 尾部.html} {/rendie:strip}