使用指导
前提条件
数据库状态正常、连接正常。
使用方法示例
以tpcc数据库为例:
gs_dbmind component sql_rewriter 5030 tpcc queries.sql --db-host 127.0.0.1 --db-user myname --schema public
queries.sql为需要改写的SQL,内容如下:
select cfg_name from bmsql_config group by cfg_name having cfg_name='1';
delete from bmsql_config;
delete from bmsql_config where cfg_name='1';
结果为多个改写后的查询语句,显示在屏幕(无法改写的语句,显示为空),如下:
+--------------------------------------------------------------------------+------------------------------+
| Raw SQL | Rewritten SQL |
+--------------------------------------------------------------------------+------------------------------+
| select cfg_name from bmsql_config group by cfg_name having cfg_name='1'; | SELECT cfg_name |
| | FROM bmsql_config |
| | WHERE cfg_name = '1'; |
| delete from bmsql_config; | TRUNCATE TABLE bmsql_config; |
| delete from bmsql_config where cfg_name='1'; | |
+--------------------------------------------------------------------------+------------------------------+
意见反馈