MySQL学习

use myblog;
-- show tables;
insert into users (username,`password`,realname) values('zhangsan','123','张三');

select*from users;
select id,username from users;

select * from users where username="zhangsan";
select * from users where username="zhangsan" and `password`="123";
select * from users where username="zhangsan" or `password`="123";

-- 模糊查询
select * from users where username like '%zhang%'; 

-- 查询排序
select * from users where password like '%1%' order by id;
select * from users where password like '%1%' order by id desc;

-- 更新
update users set realname="张三三" where username="zhangsan";
-- 22:13:52	update users set realname="张三三" where username="zhangsan"	Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column.  To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect.	0.0036 sec
SET SQL_SAFE_UPDATES = 0;

--删除
delete from users where username="zhangsan";
select * from users where status="1";
select * from users where status<>"0";  -- 查询!0
update users set status="0" where username="fangaungjian"; -- 软删除

 

报错::

解决:

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';