WHERE
ColDateTime >= DATE_SUB(Now(), INTERVAL "2:0" MINUTE_SECOND)
ColDateTime >= DATE_SUB(Now(), INTERVAL "2:0" MINUTE_SECOND)
解决方案 »
- 如何用mysql workbench导出数据库
- mysql 大表小表驱动的问题
- 怎么往表中自动插入想要的数据呢?在同一行中
- Order By 能按实例的子变量排序吗
- 问个查询,字符串联合的
- MYSQL 急!!#1016 - Can't open file: 'table_name.ibd' (errno: 1)
- MySql 批量删除记录的问题,请帮忙!
- mysql中如何复制一个表?
- 请教几个很基本的php+mysql问题,很急
- 还是两表查询问题 union all 为什么只能取到其中的前面的而后没有,求大侠指点。
- 【求助】安装MySQL出现问题!
- 在LINUX下如何查看MYSQL当前的连接呀?急!!!!
`addtime` datetime default '0000-00-00 00:00:00',
`adduser` varchar(20) binary default NULL,
`updatetime` datetime default '0000-00-00 00:00:00',
`updateuser` varchar(20) binary default NULL,
+---------------------+-----------------------------------------------+
| Now() | DATE_SUB(Now(), INTERVAL "2:0" MINUTE_SECOND) |
+---------------------+-----------------------------------------------+
| 2004-09-09 09:08:10 | 2004-09-09 09:06:10 |
+---------------------+-----------------------------------------------+
`Id` int(6) unsigned NOT NULL auto_increment,
`Name` national varchar(4) NOT NULL,
`Time` timestamp(14) NOT NULL,
PRIMARY KEY (`Id`)
) TYPE=MyISAM;INSERT INTO `ta` (`Name`) VALUES ('A');
INSERT INTO `ta` (`Name`) VALUES ('B');
INSERT INTO `ta` (`Name`) VALUES ('C');SELECT * FROM test.ta;
+------+----------+------------------------------+
| Id | Name | Time |
+------+----------+------------------------------+
| 1 | A | 20040909091032 |
| 2 | B | 20040909091323 |
| 3 | C | 20040909091331 |
+------+----------+------------------------------+SELECT *, Now()FROM `test`.`ta` WHERE `Time` >= DATE_SUB(Now(), INTERVAL "4:0" MINUTE_SECOND);
+------+----------+------------------------------+------------------------+
| Id | Name | Time | Now() |
+------+----------+------------------------------+------------------------+
| 2 | B | 20040909091323 | 2004-09-09 09:16:27 |
| 3 | C | 20040909091331 | 2004-09-09 09:16:27 |
+------+----------+------------------------------+------------------------+
方法是:select * from mmssub_dz where now()>=subdate and subdate>=DATE_SUB(Now(), INTERVAL "2:0" MINUTE_SECOND);其中subdate是我插入记录时的日期时间字段,谢谢各位啦!