You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Hi Team,
I am trying to create a query rule on one column of a table that is present in multiple MySQL databases. Can someone help me resolve this?
I have taken a look at the mysql_query_rules table in proxysql, I see the option of schema name (database name), but no option to create a rule on a particular table column which is present on multiple databases, please find my query rule below
Membership is the table I have in multiple MySQL databases on a server; I am creating a rule to add backticks to column 'rank' by using proxysql for all sorts of queries going to database via proxysql
The text was updated successfully, but these errors were encountered:
Hi Team,
I am trying to create a query rule on one column of a table that is present in multiple MySQL databases. Can someone help me resolve this?
I have taken a look at the mysql_query_rules table in proxysql, I see the option of schema name (database name), but no option to create a rule on a particular table column which is present on multiple databases, please find my query rule below
INSERT INTO mysql_query_rules (rule_id, active, schemaname, match_pattern, replace_pattern) VALUES (1, 1, '*Membership*', '([^
])rank([^])', '\1
rank\2');
Membership is the table I have in multiple MySQL databases on a server; I am creating a rule to add backticks to column 'rank' by using proxysql for all sorts of queries going to database via proxysql
The text was updated successfully, but these errors were encountered: