Debian Codegraph @

mysql-test/suite/x/include/sample_tables.inc

raw
1
2 CREATE SCHEMA IF NOT EXISTS xtest;
3 USE xtest;
4 DELIMITER //;
5
6 CREATE PROCEDURE recreate_tables()
7 BEGIN
8 CREATE TABLE IF NOT EXISTS xtable (phrase VARCHAR(30), prio INTEGER);
9 TRUNCATE TABLE xtable;
10 INSERT INTO xtable (phrase, prio) VALUES ('Alice has a cat', 1);
11 INSERT INTO xtable (phrase, prio) VALUES ('Bob has a dog 1', 2);
12 INSERT INTO xtable (phrase, prio) VALUES ('Peppa has a teddy', 1);
13 INSERT INTO xtable (phrase, prio) VALUES ('Bob has a dog 2', 3);
14 INSERT INTO xtable (phrase, prio) VALUES ('Row to delete', 4);
15
16 CREATE TABLE IF NOT EXISTS xtable_with_pk (p_id INTEGER AUTO_INCREMENT PRIMARY KEY, description varchar(40));
17 TRUNCATE TABLE xtable_with_pk;
18 INSERT INTO xtable_with_pk (description) VALUES ('MyRow');
19 END //
20
21 DELIMITER ;//