keywords.result
上传用户:romrleung
上传日期:2022-05-23
资源大小:18897k
文件大小:1k
源码类别:

MySQL数据库

开发平台:

Visual C++

  1. drop table if exists t1;
  2. create table t1 (time time, date date, timestamp timestamp);
  3. insert into t1 values ("12:22:22","97:02:03","1997-01-02");
  4. select * from t1;
  5. time date timestamp
  6. 12:22:22 1997-02-03 1997-01-02 00:00:00
  7. select t1.time+0,t1.date+0,t1.timestamp+0,concat(date," ",time) from t1;
  8. t1.time+0 t1.date+0 t1.timestamp+0 concat(date," ",time)
  9. 122222 19970203 19970102000000 1997-02-03 12:22:22
  10. drop table t1;
  11. create table events(binlog int);
  12. insert into events values(1);
  13. select events.binlog from events;
  14. binlog
  15. 1
  16. drop table events;