Debian Codegraph @

mysql-test/suite/perfschema/include/prepared_stmts_setup.inc

raw
1 #
2 # Creating various prepared statements.
3 # HELPER include/prepared_stmts_setup.inc
4 #
5
6 CREATE TABLE t1 (a INT NOT NULL);
7 INSERT INTO t1 VALUES (4), (8), (11), (32), (80);
8
9 # Prepared statments
10
11 PREPARE st1 FROM 'SELECT SQRT(POW(?,2) + POW(?,2)) AS hypotenuse';
12
13 SET @table = 't1';
14 SET @s = CONCAT('SELECT * FROM ', @table);
15 PREPARE st2 FROM @s;
16
17 PREPARE st3 FROM 'INSERT INTO t1 SELECT * FROM t1 WHERE a<=?';
18
19 PREPARE st4 FROM
20 '(SELECT a FROM t1) UNION (SELECT a+10 FROM t1) ORDER BY RAND()*0+a';