mysql常用查询语句
基本语句1、mysql -u root -p 数据库连接
2、create databases数据库名 创建数据库
3、drop database 数据库名 删除数据库
查询语句
4、SELECT * FROM 表名称 查询表中所有数据
5、SELECT> FROM student 条件查询，
6、SELECT DISTINCT addr
FROM student 查询到重复值只输出一次
7、SELECT *
FROM student
WHERE> 8、SELECT *
FROM student
WHERE name="TOM" AND age=18; 查询名字为TOM并且年龄为18
9、SELECT *
FROM student
WHERE name="T" OR age=18; 查询名字为T或者年龄为18的满足一个条件即可
10、SELECT> FROM student
ORDER BY age; 按年龄升序查询
11、INSERT INTO student VALUES (7,"MARRY",22,1,"浙江绍兴"); 像表格中插入数据
12、UPDATE student SET gender = 0; 更新表中某列的数据
13、UPDATE student SET gender = 0
WHERE> 14、DELETE
FROM student
WHERE> 15、SELECT *
FROM student
WHEREaddr LIKE "%湖%"; 查询地址中带湖的，全部输出来
16、SELECT *
FROM student
WHERE>
17、SELECT> FROM student 修改idcard的别名为id显示出来
18、SELECT student.`name`,student.age,student.addr,course.course_name,mid_stu_course.grade
FROM student
JOIN mid_stu_course ON student.idcard=mid_stu_course.idcard
JOIN course ON mid_stu_course.course_id=course.course_id
WHERE student.idcard=1; 查询idcard为1的学生的信息
19、SELECT student.idcard
FROM student
UNION
SELECT mid_stu_course.course_id
FROM mid_stu_course; 查询结果并且合并结果集
页:
[1]