1 echo CREATE TABLE t1(f1 INT AUTO_INCREMENT,f2 DATE DEFAULT 'NOW',f3 TIME DEFAULT 'NOW',f4 TIMESTAMP DEFAULT 'NOW');
2 CREATE TABLE t1(f1 INT AUTO_INCREMENT,f2 DATE DEFAULT 'NOW',f3 TIME DEFAULT 'NOW',f4 TIMESTAMP DEFAULT 'NOW');
3 echo INSERT INTO t1(f1) VALUES(10);
4 INSERT INTO t1(f1) VALUES(10);
5 echo INSERT INTO t1(f2) VALUES('NOW');
6 INSERT INTO t1(f2) VALUES('NOW');
7 echo INSERT INTO t1(f3) VALUES('NOW');
8 INSERT INTO t1(f3) VALUES('NOW');
9 echo INSERT INTO t1(f4) VALUES('NOW');
10 INSERT INTO t1(f4) VALUES('NOW');
11 echo SELECT * FROM t1;