mysql安装
1. 双击安装
2. 配置环境变量
C:\Program Files\MySQL\MySQL Server 5.7\bin
3. 初始化
mysqld -install
mysqld --initialize
4. 启动服务器
net start mysql
5. 登录(密码data 文件.err文本文件)
mysql -u root -p
输入密码
6. 修改密码
alter user 'root'@'localhost' identified by '123456';
链接mysql
1. 安装 Navicat
2. 新建链接
填入链接名与密码
3. 右键打开连接
mysql命令
查询
查询所有内容select * from user where 1
查询某个用户select * from user where name='zeng8' and password='zmm123'
分数大于500select * from user where score>500
name zeng_的_代表任意一个字符%代表一个或者多个字符
select * from user where name like 'zeng_'
select * from user where name like 'zeng%'
查询所有用户,从1开始,截取2条
select * from user where 1 limit 1,2
查询所有用户,按分数排序,升序acs 降序 desc
select * from user where 1 order by score asc
查询两个字段
select name,score from user where 1
插入
insert into user (name,password,score)
values ('zeng11','zmm123',120)
修改 把zeng8的分数改为2500
update user set score=2500 where name='zeng8'
把zeng_ 分数改变2500 _代表任意字符
update user set score=2500 where name like 'zeng_'
update 更新
user 表
set 设置
score=2500 分数改为2500
where 条件
name="zeng8" 名称等于zeng8
删除
DELETE from user where id=5
删除user中id为5的行
delete 删除
from 从
user