1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
CREATE TABLE t1 (a blob default '');
drop table t1;
CREATE TABLE t1 (a blob);
ALTER TABLE t1 ALTER a SET DEFAULT '';
DROP TABLE t1;
CREATE TABLE t1 (a timestamp default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP);
ALTER TABLE t1 ALTER a SET DEFAULT '2011-01-01 10:00:00';
SHOW CREATE TABLE t1;
Table Create Table
t1 CREATE TABLE `t1` (
`a` TIMESTAMP NULL DEFAULT '2011-01-01 10:00:00' ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB COLLATE = utf8_general_ci
DROP TABLE t1;
CREATE TABLE t1 (a timestamp ON UPDATE CURRENT_TIMESTAMP);
ALTER TABLE t1 ALTER a SET DEFAULT '2011-03-07 17:45:00';
SHOW CREATE TABLE t1;
Table Create Table
t1 CREATE TABLE `t1` (
`a` TIMESTAMP NULL DEFAULT '2011-03-07 17:45:00' ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB COLLATE = utf8_general_ci
DROP TABLE t1;
|