【 Mysql增删改查基础应用】

最新推荐文章于 2024-10-02 06:14:43 发布

super_DJ

最新推荐文章于 2024-10-02 06:14:43 发布

阅读量338

点赞数

本文链接：https://blog.csdn.net/super_DJ/article/details/123207355

版权

MySQL 数据库增删改查查询语法数据操作

关键词由CSDN通过智能技术生成

Mysql增删改查基础应用

新建一个Mysql表单进行练习

创建表单

SELECT
*
FROM
score;
INSERT INTO score ( id, NAME, age, sex, address, math, english, hire_date )
VALUES
(
1,
‘马云’,
55,
‘男’,
‘深圳’,
55,
66,
‘1999-05-01’),
(
2,
‘马花藤’,
45,
‘男’,
‘杭州’,
98,
87,
‘1998-09-01’),
(
3,
‘马保国’,
80,
‘男’,
‘香山’,
20,
20,
‘1909-08-08’),
(
4,
‘刘德华’,
20,
‘女’,
‘深圳’,
76,
100,
‘1999-8-08’),
(
5,
‘张学友’,
55,
‘男’,
‘郑州’,
50,
100,
‘1999-05-01’),
(
6,
‘马六’,
55,
‘男’,
‘深圳’,
55,
66,
‘1999-05-01’),
(
7,
‘马七’,
55,
‘男’,
‘深圳’,
55,
66,
‘1999-05-01’);
SELECT
*
FROM
score;
– 基础查询==================================

-- 查询两列数据 name age

SELECT NAME,age FROM score;

-- 查询所有列的数据

SELECT * FROM score
-- 查询地址信息
SELECT address from score;

-- 去除重复记录
SELECT DISTINCT address FROM score;

-- 查询姓名，数学成绩，英语成绩

SELECT name as 姓名,math as 数学成绩,english as 英语成绩  FROM score;

-- 查询年龄大于等于20岁的学员信息 (小于同理)
SELECT *from score where age >=20;

-- 查询年龄大于等于20岁小于50岁的学员信息
SELECT *from score where age >=20 and age<=50;

-- 查询入学时间在'1998-9-01'到'1999-09-01'之间的学员信息

	SELECT *from score where hire_date BETWEEN'1998-9-01'and'1999-09-01';
-- 查询年龄等于20的学员信息
SELECT *from score where age =20;
	-- 查询年龄不等于20的学员信息

	SELECT *from score where age !=20;
	-- 查询年龄等于20 或者45  或者80岁的学员信息
	SELECT *from score where age =20 or age =45 or age =80;
	
	-- 查询英语成绩不为null的学员信息   null不能用=或！=判断，需要用 is ,not is 来判断
	
			SELECT *from score where english  is not null;