{"action":"created","issue":{"url":"https://api.github.com/repos/sysown/proxysql/issues/759","repository_url":"https://api.github.com/repos/sysown/proxysql","labels_url":"https://api.github.com/repos/sysown/proxysql/issues/759/labels{/name}","comments_url":"https://api.github.com/repos/sysown/proxysql/issues/759/comments","events_url":"https://api.github.com/repos/sysown/proxysql/issues/759/events","html_url":"https://github.com/sysown/proxysql/issues/759","id":185662121,"number":759,"title":"how to set the mysql_query_rules for testing prepare statment","user":{"login":"jkklee","id":11570771,"avatar_url":"https://avatars.githubusercontent.com/u/11570771?v=3","gravatar_id":"","url":"https://api.github.com/users/jkklee","html_url":"https://github.com/jkklee","followers_url":"https://api.github.com/users/jkklee/followers","following_url":"https://api.github.com/users/jkklee/following{/other_user}","gists_url":"https://api.github.com/users/jkklee/gists{/gist_id}","starred_url":"https://api.github.com/users/jkklee/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jkklee/subscriptions","organizations_url":"https://api.github.com/users/jkklee/orgs","repos_url":"https://api.github.com/users/jkklee/repos","events_url":"https://api.github.com/users/jkklee/events{/privacy}","received_events_url":"https://api.github.com/users/jkklee/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":14,"created_at":"2016-10-27T13:02:15Z","updated_at":"2016-10-28T03:26:25Z","closed_at":null,"body":"I think we can set `prepare` with regexp like `^prepare .* from [\\'\\\"\\ ]select.*` etc. But how to set the `set` and `execute` statment?"},"comment":{"url":"https://api.github.com/repos/sysown/proxysql/issues/comments/256827604","html_url":"https://github.com/sysown/proxysql/issues/759#issuecomment-256827604","issue_url":"https://api.github.com/repos/sysown/proxysql/issues/759","id":256827604,"user":{"login":"jkklee","id":11570771,"avatar_url":"https://avatars.githubusercontent.com/u/11570771?v=3","gravatar_id":"","url":"https://api.github.com/users/jkklee","html_url":"https://github.com/jkklee","followers_url":"https://api.github.com/users/jkklee/followers","following_url":"https://api.github.com/users/jkklee/following{/other_user}","gists_url":"https://api.github.com/users/jkklee/gists{/gist_id}","starred_url":"https://api.github.com/users/jkklee/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jkklee/subscriptions","organizations_url":"https://api.github.com/users/jkklee/orgs","repos_url":"https://api.github.com/users/jkklee/repos","events_url":"https://api.github.com/users/jkklee/events{/privacy}","received_events_url":"https://api.github.com/users/jkklee/received_events","type":"User","site_admin":false},"created_at":"2016-10-28T03:26:25Z","updated_at":"2016-10-28T03:26:25Z","body":"You mean:\r\n    when application send statements to mysql-server like `prepare...`, `set...`,`execute...`, it's use the **SQL prepared statements (text protocol)**?\r\n    when application send statements to mysql-server like `select/update/insert/delete...` even though app's code use the 'prepare/set/execute' statement, it's use the **application prepared statements (binary protocol)**?"}}
{"actor":{"display_login":"jkklee"}}