Mysql
飞翔的乌龟
这个作者很懒,什么都没留下…
展开
-
解决mysql的查询sql中limit和in不能同时使用的问题
使用mysql数据库编写sql语句时,可能会遇到如下情况:select * from sms_contentwhere id in (SELECT id from sms_content limit 0,5);出现错误:[SQL]select * from sms_contentwhere id in (SELECT id from sms_content limit 0,5);[Err] ...原创 2018-03-09 16:58:03 · 4957 阅读 · 1 评论 -
Mysql服务器停电,如何恢复启动
首先查看Mysql的日志信息出现如下几行错误信息:[ERROR] Found 1 prepared transactions! It means that mysqld was not shut down properly last time and critical recovery information (last binlog or tc.log file) was manually...原创 2019-03-14 18:39:21 · 2066 阅读 · 0 评论