Debian Codegraph @

mysql-test/suite/query_rewrite_plugins/include/trivial.inc

raw
1 DELETE FROM query_rewrite.rewrite_rules;
2
3 INSERT INTO query_rewrite.rewrite_rules ( pattern, replacement )
4 VALUES ( 'SELECT * FROM mydb.mytable WHERE mycol = ?', 'select "rule1"' );
5
6 CALL query_rewrite.flush_rewrite_rules();
7
8 CREATE DATABASE mydb;
9 CREATE TABLE mydb.mytable ( mycol char(3), mycol2 CHAR(100) );
10 INSERT INTO mydb.mytable VALUES ( 'xxx', 'Not supposed to be seeing this.' );
11
12 SELECT * FROM mydb.mytable WHERE mycol = 'xxx';
13
14 DROP DATABASE mydb;