1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
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;
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;
DROP TABLE t1;
|