tools-mysql-总结

关闭安全模式

show variables like 'SQL_SAFE_UPDATES';
SET SQL_SAFE_UPDATES = 0;

---

字段加密

insert into sir2.user_extern_info (user_id, user_name,role_id,login_pw) VALUES ('45566','admin','3',password('admin'));

SELECT role_id FROM sir2.user_extern_info where user_name ='admin'and login_pw =  PASSWORD('admin') ;

嵌套查询

SELECT * FROM new_schema3.t_iris where id=(SELECT id FROM new_schema3.t_user where username='程征'); 
//转换成下面语句
select *FROM t_user ,t_iris where t_user.id=t_iris.userid and t_user.username='程征'

判断某个表是否存在

std::string SELECTTABLEEXIST = "select * from information_schema.TABLES where table_schema ='mydb' and table_name = 'student';";