一、常用操作
1,强制结束一段命令
ctrl+c 然后回车。
1.启动本地的mysql
以管理员身份启动CMD
输入命令:net start mysql
2.登录数据库
命令:
mysql -uroot -p
然后输入密码,回车
二、SQL语句
举例 | 备注 | |||
NULL | 判断为NULL | IS NULL | WHERE name IS NULL | |
<=> NULL | WHERE name <=> NULL | |||
判断不为NULL | IS NOT NULL | WHERE name IS NOT NULL | ||
WHERE !(name <=> NULL) | ||||
范围查询 | 区间范围 | between 10 and 15 | where age between 16 and 18 | |
not between 10 and 15 | ||||
集合范围 | in (a,b,c) | |||
not in (a,b,c) | ||||
模糊查询 | LIKE | WHERE name LIKE '张%' | %代表任意个字符 | |
WHERE name LIKE '_明' | _代表一个字符,两个下划线代表2个字符 |
1、查询某个字段为null的值。
判断null不能用=。SELECT * FROM table WHERE name = NULL是错误。
要使用IS NULL 或者安全等号<=>
举例:
SELECT * FROM table WHERE name IS NULL
或者
SELECT * FROM table WHERE name <=> NULL
判断不为NULL,使用 IS NOT NULL
SELECT * FROM table WHERE name IS NOT NULL
或者
SELECT * FROM table WHERE !(name <=> NULL)
2、范围查询
区间范围 :
between a and b
not between a and b
select * from Student where age between 16 and 18
select * from Student where age not between 16 and 18
集合范围:
in (a,b,c)
not in (a,b,c)
2.3 模糊匹配比较运算符
一般应用于字符串的查询