mysql01

Python连接MySQL数据库
https://www.jianshu.com/p/76fab6cb06f9

[Python] 用Session()优化requests的性能
https://zhuanlan.zhihu.com/p/114283369

 mysql -u root -p -P 3306
 小p表示用密码登陆
show VARIABLES ;
show global STATUS ;
show variables LIKE '%connections%';
set GLOBAL max_connections=1024;

select price,contents from goods where id=1


SELECT user FROM user;
CREATE user qiz IDENTIFIED BY 'P=r3wC4+';
SHOW GRANTS FOR qiz;
SHOW ENGINES;
SHOW COLLATION;
SHOW CHARSET;
STATUS;
SELECT SOUNDEX('你好');
SELECT RAND()*1000;
show databases;