MySQL常见的查询语句的运用
来源:互联网 发布:晋城网络推广经理招聘 编辑:程序博客网 时间:2024/06/06 03:24
数据库基本查询语句:
insert into 表名 values (数据1,数据2,数据3.。。。。。。),(数据1,数据2,数据3.。。。。。。)
INSERT into student (stuid,name,sex,phone,birthday,cid) VALUES (1,"王一",'男',13888888888,'20010301',1)
修改
update 表名 set 字段= 新值 where 条件
UPDATE student SET cid=2 WHERE `name`="王一"
删除
delete from 表名//表里所有的数据删除
delete from 表名 where 条件
DELETE from student WHERE NAME='王八'
查询
select 需要的结果 from 表名
SELECT name FROM student
select 需要的结果 from 表名 where 条件
SELECT cid from student WHERE name='王一'
SELECT name,score from student
SELECT name,score+10 from student
SELECT name as "姓名",score+10 '成绩'from student
SELECT score from student WHERE sex<>'女'
SELECT name from student WHERE score>60
SELECT * from student WHERE score BETWEEN 60 AND 80
SELECT * from student WHERE score in (10,60,80)
SELECT * from student WHERE name LIKE "王%"//% 匹配一个及多个字符
SELECT * from student WHERE name LIKE "王_"// _ 匹配一个字符
SELECT * from student WHERE score>70 and cid=1 //and 与 or 或 NOT 非
SELECT avg(score) FROM student WHERE cid=1
SELECT sum(score) FROM student WHERE cid=1
SELECT max(score) FROM student WHERE cid=1
SELECT min(score) FROM student WHERE cid=1
SELECT COUNT(name) from student WHERE score>60
SELECT cid,avg(score) from student GROUP BY cid
SELECT sex,cid,avg(score) from student GROUP BY cid,sex
SELECT stuid ,score+5 as sa from student HAVING sa>60
SELECT * from student ORDER BY score ASC//从小到大
SELECT * from student ORDER BY score DESC//从大到小
SELECT cid,avg(score) from student GROUP BY cid HAVING avg(score)>60 ORDER BY avg(score) DESC
SELECT * from student ORDER BY score DESC LIMIT 1,3
SELECT * from student,classinfo WHERE student.cid=classinfo.cid
SELECT name,cname FROM student,classinfo WHERE student.cid=classinfo.cid
SELECT student.name '姓名',classinfo.cname '班级名' FROM student,classinfo WHERE student.cid=classinfo.cid
SELECT student.stuid,student.name,student.cid,classinfo.cname from student,classinfo WHERE student.cid=classinfo.cid AND student.name='王一'
insert into 表名 values (数据1,数据2,数据3.。。。。。。),(数据1,数据2,数据3.。。。。。。)
INSERT into student (stuid,name,sex,phone,birthday,cid) VALUES (1,"王一",'男',13888888888,'20010301',1)
修改
update 表名 set 字段= 新值 where 条件
UPDATE student SET cid=2 WHERE `name`="王一"
删除
delete from 表名//表里所有的数据删除
delete from 表名 where 条件
DELETE from student WHERE NAME='王八'
查询
select 需要的结果 from 表名
SELECT name FROM student
select 需要的结果 from 表名 where 条件
SELECT cid from student WHERE name='王一'
SELECT name,score from student
SELECT name,score+10 from student
SELECT name as "姓名",score+10 '成绩'from student
SELECT score from student WHERE sex<>'女'
SELECT name from student WHERE score>60
SELECT * from student WHERE score BETWEEN 60 AND 80
SELECT * from student WHERE score in (10,60,80)
SELECT * from student WHERE name LIKE "王%"//% 匹配一个及多个字符
SELECT * from student WHERE name LIKE "王_"// _ 匹配一个字符
SELECT * from student WHERE score>70 and cid=1 //and 与 or 或 NOT 非
SELECT avg(score) FROM student WHERE cid=1
SELECT sum(score) FROM student WHERE cid=1
SELECT max(score) FROM student WHERE cid=1
SELECT min(score) FROM student WHERE cid=1
SELECT COUNT(name) from student WHERE score>60
SELECT cid,avg(score) from student GROUP BY cid
SELECT sex,cid,avg(score) from student GROUP BY cid,sex
SELECT stuid ,score+5 as sa from student HAVING sa>60
SELECT * from student ORDER BY score ASC//从小到大
SELECT * from student ORDER BY score DESC//从大到小
SELECT cid,avg(score) from student GROUP BY cid HAVING avg(score)>60 ORDER BY avg(score) DESC
SELECT * from student ORDER BY score DESC LIMIT 1,3
SELECT * from student,classinfo WHERE student.cid=classinfo.cid
SELECT name,cname FROM student,classinfo WHERE student.cid=classinfo.cid
SELECT student.name '姓名',classinfo.cname '班级名' FROM student,classinfo WHERE student.cid=classinfo.cid
SELECT student.stuid,student.name,student.cid,classinfo.cname from student,classinfo WHERE student.cid=classinfo.cid AND student.name='王一'
阅读全文
0 0
- MySQL常见的查询语句的运用
- mysql常见的时间查询语句
- 高性能MySql进化论(十一):常见查询语句的优化
- 高性能MySql进化论(十一):常见查询语句的优化
- 高性能MySql进化论(十一):常见查询语句的优化
- MySQL常见查询语句
- Oracle常见的查询语句
- 常见的sql查询语句
- 面试常见的查询语句
- SQL之查询语句的实践运用
- mysql的查询语句
- [SQL]常见的mysql 语句
- mysql 中 case 语句的运用
- MySql常见的错误代码查询
- mysql的经典查询语句
- mysql的经典查询语句
- mysql的查询select 语句
- MySql的DQL语句,查询
- Linux的常用指令
- 实用Chrome插件-OneTab
- 使用J-flash arm下载程序
- tf.while_loop
- Stock Chase--HDOJ
- MySQL常见的查询语句的运用
- 使用安信可ESP8266IDE编辑工具使用最新的乐鑫RTOS固件
- Linux的SOCKET编程详解
- Lua 5.3 源码分析(十)线程的执行与中断
- java设计模式之代理模式举例
- IDEA下创建Web项目
- java服务器对json数据进行gzip压缩
- PIL 库的使用入门
- 静态代理和动态代理