pt-fingerprint --query "SELECT id,`group`,shop_id,org_name,pid,is_show,org_level,root_id,path,agent_num FROM sbt1...command not found: group
select id,,shop_id,org_name,pid,is_show,org_level,root_id,path,agent_num from sbt1...内容如下:
package main
import (
"fmt"
"os"
"github.com/percona/go-mysql/query"
)
func main() {
// 仅从命令行参数读取查询语句...rt_time unlimited,shop_id,org_name,pid,is_show,org_level,root_id,path,agent_num from sbt1 where name...解决办法:
在使用前,先处理一次,使用replace将反引号去掉
对于sql归一化,业内还有很多工具,例如:
1、tidb sql parser
2、jsqlparser
3、druid ,示例可以参考这篇