[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 · 626 阅读 · 0 评论 -
【MySQL】MySQL5.5源码SourceCode的安装部署方法
安装cmake wget 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 · 1921 阅读 · 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 · 7496 阅读 · 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 · 8844 阅读 · 0 评论