![](https://img-blog.csdnimg.cn/20201014180756780.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
YY小姐姐
小姐姐程序员
展开
-
mysql大表删除更新操作
mysql大表删除更新操作 //大表删除修改数据 CREATE PROCEDURE p_del_rows () BEGIN DECLARE v_rows INT; SET v_rows = 1; WHILE v_rows > 0 DO DELETE FROM shop_info WHERE id >= 9000 AND id <= 190000 LIMIT 5000; SELECT ROW_COUNT() INTO v_r原创 2021-04-07 00:53:39 · 121 阅读 · 0 评论 -
MySQL:Table‘performance_schema.session_variables‘ doesn‘t exist
MySQL:Table’performance_schema.session_variables’ doesn’t exist 解决方案:找到mysql.exe mysql -u root -p 登录 执行:set global show_campatibility_56=on; 即可加粗样式原创 2020-09-23 18:18:09 · 172 阅读 · 0 评论