delayed.result
上传用户:romrleung
上传日期:2022-05-23
资源大小:18897k
文件大小:1k
- drop table if exists t1;
- create table t1 (a char(10), tmsp timestamp);
- insert into t1 set a = 1;
- insert delayed into t1 set a = 2;
- insert into t1 set a = 3, tmsp=NULL;
- insert delayed into t1 set a = 4;
- insert delayed into t1 set a = 5, tmsp = 19711006010203;
- insert delayed into t1 (a, tmsp) values (6, 19711006010203);
- insert delayed into t1 (a, tmsp) values (7, NULL);
- insert into t1 set a = 8,tmsp=19711006010203;
- select * from t1 where tmsp=0;
- a tmsp
- select * from t1 where tmsp=19711006010203;
- a tmsp
- 5 1971-10-06 01:02:03
- 6 1971-10-06 01:02:03
- 8 1971-10-06 01:02:03
- drop table t1;
- create table t1 (a int not null auto_increment primary key, b char(10));
- insert delayed into t1 values (1,"b");
- insert delayed into t1 values (null,"c");
- insert delayed into t1 values (3,"d"),(null,"e");
- insert delayed into t1 values (3,"this will give an","error");
- ERROR 21S01: Column count doesn't match value count at row 1
- select * from t1;
- a b
- 1 b
- 2 c
- 3 d
- 4 e
- drop table t1;