1
CREATE TABLE t1 (a blob default '');
3
CREATE TABLE t1 (a blob);
4
ALTER TABLE t1 ALTER a SET DEFAULT '';
6
CREATE TABLE t1 (a timestamp default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP);
7
ALTER TABLE t1 ALTER a SET DEFAULT '2011-01-01 10:00:00';
10
t1 CREATE TABLE `t1` (
11
`a` TIMESTAMP NULL DEFAULT '2011-01-01 10:00:00' ON UPDATE CURRENT_TIMESTAMP
12
) ENGINE=InnoDB COLLATE = utf8_general_ci
14
CREATE TABLE t1 (a timestamp ON UPDATE CURRENT_TIMESTAMP);
15
ALTER TABLE t1 ALTER a SET DEFAULT '2011-03-07 17:45:00';
18
t1 CREATE TABLE `t1` (
19
`a` TIMESTAMP NULL DEFAULT '2011-03-07 17:45:00' ON UPDATE CURRENT_TIMESTAMP
20
) ENGINE=InnoDB COLLATE = utf8_general_ci