简单、可复制、实践

随笔分类 -  Mysql

Mysql 数据库crash恢复
摘要：之前搭建的ghost博客比较坑，修改comment之后重启数据丢了，对node不熟悉，所以就切换回到wordpress了。 回滚快照之后发现数据库crash了，提示如下信息 2016 06 15 23:21:32 3344 [Note] InnoDB: Database was not shutdo 阅读全文
posted @ 2016-07-13 09:52 若水天涯 阅读(1810) 评论(0) 推荐(0)
mysql 多表join
摘要：两个表可以简单地写为select a.*,b.* from a left join b on a.id =b.id;三个以上select a.*,b.* from a left join b on a.id=b.id left join c on a.id=b.id where具体的例子select... 阅读全文
posted @ 2015-08-29 22:48 若水天涯 阅读(489) 评论(0) 推荐(0)
mysql InnoDB: Assertion failure in thread xxxx in file ut0mem.cc line 105
摘要：mysql InnoDB: Assertion failure in thread xxxx in file ut0mem.cc line 105错误信息InnoDB: Assertion failure in thread xxxx in file ut0mem.cc line 105InnoDB... 阅读全文
posted @ 2015-08-29 22:42 若水天涯 阅读(4602) 评论(0) 推荐(0)