随笔分类 -  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 阅读全文
posted @ 2023-09-15 17:24 进阶的哈姆雷特 阅读(360) 评论(0) 推荐(0)
linux mysql
摘要：mysql -u root -p; mysql> create database ghost; mysql> show databases; mysql> exit mysql> select user(); // 查看当前登录的用户 mysql> show global variables lik 阅读全文
posted @ 2023-02-19 23:28 进阶的哈姆雷特 阅读(26) 评论(0) 推荐(0)
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 阅读全文
posted @ 2020-02-18 15:25 进阶的哈姆雷特 阅读(187) 评论(0) 推荐(0)