mysql
虎城威威
这个作者很懒,什么都没留下…
展开
-
mysql查询库所有表和字段
SELECT TABLE_NAME,column_name,COLUMN_TYPE,COLUMN_COMMENT FROM information_schema.columns WHERE table_schema = 'mcc' AND table_name in ( select TABLE_NAME from information_schema.tables where tabl原创 2017-07-18 17:43:51 · 506 阅读 · 0 评论 -
Host '10.10.120.174' is blocked beacuse of many connection errors;
Host '10.10.120.174' is blocked beacuse of many connection errors;unblock with 'mysqldamin flush-hosts'#使用清楚缓存的方法,这样就会把计数清理掉,进入mysql控制台,执行:flush hosts;/usr/bin/mysqladmin -u jiaobo -puukkgg flush-ho...原创 2018-05-07 09:00:59 · 245 阅读 · 0 评论 -
Mysql
搭建https://blog.csdn.net/qq_42035966/article/details/82085696 Q:ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes 解决方案:http://www.cnblogs.com/kerrycode/p/9680881.html ...原创 2019-01-25 13:25:46 · 243 阅读 · 1 评论