mysql
Trier_
我很懒,我什么也没有留下
展开
-
DBSyncer mysql 增量 配置
DBSyncer mysql 增量 配置原创 2022-06-13 15:06:27 · 1465 阅读 · 5 评论 -
mysql 行转列
select sname, max(case cname when 'java' then (case when score - (select avg(score) from subject where cname = 'java') > 20 then 'A' when score-(select avg(score) from subject where cname = '原创 2021-12-03 14:13:17 · 148 阅读 · 0 评论 -
mysql error 1130 host ‘192.168.1.3‘ is not allowed to connect to thisMySQL serve
错误:ERROR 1130: Host ‘192.168.1.3’ is not allowed to connect to thisMySQL serve错误1130:主机192.168.1.3”不允许连接到thismysql服务原因:被连接的数据不允许使用 192.168.1.3访问,只允许是用 localhost;1.cmd2.mysql -u -root -p3.use mysql;4.select ‘host’ from user where user=‘root’;5.update原创 2021-03-14 12:11:34 · 141 阅读 · 0 评论