nizhengjia的专栏

把sql导到本地，执行存储过程 或者 查看视频报错：mysql 1449 ： The user specified as a definer ('root'@'%') does not exist 解决方法权限问题，授权 给 root  所有sql 权限  mysql> grant all privileges on *.* to root@"%" identifi...

mysql命令：SHOW PROCESSLIST ; --显示有哪些线程在运行SELECT id,USER ,HOST,db,command,TIME,state,info FROM information_schema.processlist WHERE db='Sunivo_Settlement' AND state = 'Locked'; SELECT CONCAT...