2
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
5
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
7
DROP TABLE IF EXISTS t1;
8
DROP TABLE IF EXISTS t2;
9
DROP PROCEDURE IF EXISTS p1;
10
DROP PROCEDURE IF EXISTS p2;
11
CREATE TABLE IF NOT EXISTS t1(name CHAR(16), birth DATE,PRIMARY KEY(name))ENGINE=NDBCLUSTER;
12
CREATE TABLE IF NOT EXISTS t2(name CHAR(16), age INT ,PRIMARY KEY(name))ENGINE=NDBCLUSTER;
15
DECLARE done INT DEFAULT 0;
18
DECLARE cur1 CURSOR FOR SELECT name,
19
(YEAR(CURDATE())-YEAR(birth))-(RIGHT(CURDATE(),5)<RIGHT(birth,5))
21
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
25
FETCH cur1 INTO spa, spb;
28
INSERT INTO t2 VALUES (spa,spb);
31
UNTIL done END REPEAT;
37
INSERT INTO t1 VALUES ('MySQL','1993-02-04'),('ROCKS', '1990-08-27'),('Texas', '1999-03-30'),('kyle','2005-1-1');