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
create database if not exists mysqltest1;
8
DROP TABLE IF EXISTS mysqltest1.t1;
9
CREATE TABLE mysqltest1.t1 (n MEDIUMINT NOT NULL AUTO_INCREMENT,
10
a TIMESTAMP DEFAULT '2005-05-05 01:01:01',
11
b TIMESTAMP DEFAULT '2005-05-05 01:01:01',
13
CREATE FUNCTION mysqltest1.f1() RETURNS TIMESTAMP
15
DECLARE v1 INT DEFAULT 300;
21
INSERT INTO mysqltest1.t1 VALUES(NULL,NOW(),mysqltest1.f1());
22
CREATE TRIGGER mysqltest1.trig1 BEFORE INSERT ON mysqltest1.t1
24
SET new.b = mysqltest1.f1();
26
INSERT INTO mysqltest1.t1 SET n = NULL, a = now();
27
DROP TABLE IF EXISTS mysqltest1.t1;
28
DROP FUNCTION mysqltest1.f1;
29
DROP DATABASE mysqltest1;