[2016年以后] mysql
文章平均质量分 71
徐长亮
大数据工程师
展开
-
character sets and collations in mysql
--1 character sets and collations in mysql--2 set character sets and collations in mysql--3 客户端连接的character sets and collations原创 2016-09-11 22:06:47 · 633 阅读 · 0 评论 -
【MySQL】MySQL5.5源码SourceCode的安装部署方法
安装cmakewget http://www.cmake.org/files/v2.8/cmake-VERSION.tar.gz# tar zxvf cmake-VERSION.tar.gz# cd cmake-VERSION#./bootstrap#make#make install原创 2015-03-05 13:29:14 · 1930 阅读 · 0 评论 -
mysql sql技巧: 子查询改为连接查询&&涉及多个表的删除和更新
涉及多个表的delete语句 可以使用select语句中的任意一个联结操作语法,from字句列出删除的表,using用来联结表 delete from t1 using t1 inner join t2 on t1.id=t2.id;delete from t1,t2 using t1 inner join t2 on t1.id=t2.id;原创 2016-10-22 16:08:17 · 7517 阅读 · 0 评论 -
linux使用yum安装MySQL5.6及Unknown/unsupported storage engine: InnoDB处理
If you're using MySQL 5.6+ and want to disable InnoDB, don't forget "--default-tmp-storage" or it won't work:原创 2016-10-19 15:43:43 · 8863 阅读 · 0 评论