http://200yi.com/ff_internal/ 2026-04-28T01:13:21+0800 http://200yi.com/ff_internal/ http://200yi.com/ff_internal/lib/tpl/mnml-blog/images/favicon.ico text/html 2023-06-17T21:25:18+0800 Anonymous (anonymous@undisclosed.example.com) http://200yi.com/ff_internal/wiki.php?id=wiki:Database:MySQL:Linux%E6%BA%90%E7%A0%81%E7%BC%96%E8%AF%91%E5%AE%89%E8%A3%85MySQL8&rev=1687008318&do=diff 本文在CentOS 7上测试通过。 一、准备 关于boost库 官网源码有带boost库的源码和不带boost库的源码两种，因此有两种安装方式，其实都是一样的，仅仅是不带boost库源码的需要单独安装boost。 text/html 2023-06-17T21:25:18+0800 Anonymous (anonymous@undisclosed.example.com) http://200yi.com/ff_internal/wiki.php?id=wiki:Database:MySQL:MySQL%20Full%20Join%E7%AD%89%E4%BB%B7%E6%94%B9%E5%86%99&rev=1687008318&do=diff MySQL Full Join等价改写 MySQL不支持Full Join，可以这样改写： select * from t1 full join t2 on t1.id = t2.id; 等价改写 => select * from t1 left join t2 on t1.id = t2.id union all select * from t1 right join t2 on t1.id = t2.id where t1.id is null; text/html 2023-06-17T21:25:18+0800 Anonymous (anonymous@undisclosed.example.com) http://200yi.com/ff_internal/wiki.php?id=wiki:Database:MySQL:Windows%E6%89%8B%E5%8A%A8%E5%AE%89%E8%A3%85MySQL8.0.15&rev=1687008318&do=diff 以下介绍Windows 7 64位（其它版本系统大同小异）系统，手动安装MySQL方法。 一、下载MySQL包 从以下位置选择需要的MySQL程序包，本文使用8.0.15版本，下载后的包为mysql-8.0.15-winx64.zip https://downloads.mysql.com/archives/community/ 二、安装