随笔分类 - mysql
SQL 获取当前部门、部门人员，以及它的子级
摘要：部门及子部门 ( WITH RECURSIVE dept AS ( SELECT id, jgjc as name, jgbm as jgbh, sjjgbh, 'JG' as type FROM t_jgxx WHERE jgbm = '111111' and isdel = 0 UNION AL
linux mysql
摘要：mysql -u root -p; mysql> create database ghost; mysql> show databases; mysql> exit mysql> select user(); // 查看当前登录的用户 mysql> show global variables lik
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
摘要：node 连接数据库时报的错误。 mysql8.0以上加密方式，Node还不支持。 mysql> alter user 'root'@'localhost' identified with mysql_native_password by '1234';mysql> flush privileges
