Mysql支持查询重写插件
1、是服务端插件
2、支持的语句:
Mysql 8.0.12: Select 、Insert、Replace、Update、Delete;
Mysql 8.0.12:仅支持Select
3、涉及的数据库:query_rewrite
表:rewrite_rules
存储过程:flush_rewrite_rules
函数:load_rewrite_rules
一、安装/卸载 Rewriter Query Rewrite Plugin
1、脚本位置:Mysql安装目录share目录下面: install_rewriter.sql 、uninstall_rewriter.sql
2、安装:
$>mysql -u root -p < install_rewriter.sql
Enter password:(enter root password here)
mysql> SHOW GLOBAL VARIABLES LIKE 'rewriter_enabled';
+------------------+-------+
| Variable_name | Value |
+------------------+-------+
| rewriter_enabled | ON |
+------------------+-------+
</