![](https://img-blog.csdnimg.cn/20201014180756757.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
happy_wealthy
这个作者很懒,什么都没留下…
展开
-
Python与MySQL交互
pymysql原创 2022-12-03 23:42:43 · 1864 阅读 · 2 评论 -
linux安装mysql
https://www.cnblogs.com/baoshu/p/centos-mysql.html https://www.jb51.net/article/108035.htm原创 2021-09-23 12:34:47 · 73 阅读 · 0 评论 -
安装mysql
https://www.cnblogs.com/baoshu/p/centos-mysql.html原创 2021-08-18 00:43:35 · 61 阅读 · 0 评论 -
mysql重启
systemctl stop mysql systemctl start mysql原创 2021-08-05 11:19:54 · 45 阅读 · 0 评论 -
mysql重启
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/data/MysqlData/mysql.sock’ (111) 1、mysql重启 sudo systemctl restart mysqld 2、查看mysql是否启动状态 service mysqld status原创 2021-07-20 10:37:20 · 64 阅读 · 0 评论 -
mysql数据备份
https://www.cnblogs.com/markLogZhu/p/11398028.html原创 2021-07-15 16:23:39 · 64 阅读 · 0 评论 -
mysql统计数据表格行数
select count(*) from rule_ceshi.operation_log;原创 2021-07-13 10:58:56 · 255 阅读 · 0 评论 -
mysql成批kill进程
mysql> SELECT concat(‘KILL ‘,id,’;’) FROM information_schema.processlist WHERE user=‘root’; ±-----------------------+ | concat(‘KILL ‘,id,’;’) ±-----------------------+ | KILL 3101; | KILL 2946; ±-----------------------+ 2 rows IN SET (0.00 sec) mysql&g原创 2021-07-12 10:46:20 · 269 阅读 · 0 评论 -
“Data too long for column ‘description‘ at row 1
bug "Data too long for column 'description' at row 1 解决方案: SET @@global.sql_mode= ‘NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION’; SELECT @@global.sql_mode;原创 2021-06-17 22:44:30 · 293 阅读 · 0 评论 -
mysql里的wait_timeout设置不生效的问题解决
show variables like ‘%timeout%’; set wait_timeout=31536000; set interactive_timeout=31536000; 退出后,又变为原来的数。 解决方案:原创 2021-04-07 10:41:32 · 1153 阅读 · 0 评论