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

MySQL数据库

开发平台:

Visual C++

  1. #
  2. # Test keywords as fields
  3. #
  4. --disable_warnings
  5. drop table if exists t1;
  6. --enable_warnings
  7. create table t1 (time time, date date, timestamp timestamp);
  8. insert into t1 values ("12:22:22","97:02:03","1997-01-02");
  9. select * from t1;
  10. select t1.time+0,t1.date+0,t1.timestamp+0,concat(date," ",time) from t1;
  11. drop table t1;
  12. create table events(binlog int);
  13. insert into events values(1);
  14. select events.binlog from events;
  15. drop table events;
  16. # End of 4.1 tests