DROP TABLE IF EXISTS `times`;
CREATE TABLE `times` (
`Id` int(11) NOT NULL AUTO_INCREMENT,
`date1` timestamp NULL DEFAULT NULL,
`isPass` int(11) DEFAULT NULL,
PRIMARY KEY (`Id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=gb2312;#
# Dumping data for table times
#
LOCK TABLES `times` WRITE;
/*!40000 ALTER TABLE `times` DISABLE KEYS */;INSERT INTO `times` VALUES (1,'2010-05-17 11:20:28',0);
INSERT INTO `times` VALUES (2,'2010-05-13 14:34:04',0);
INSERT INTO `times` VALUES (3,'2010-05-13 14:34:31',0);
检查一下date1字段时间是否是今天发生的,如果是isPass字段更新为1,如果不是则默认为0
得到结果为
id isPass
1 1
2 0
3 0
解决方案 »
- 如何通过一个表的字段去更新另一个表的字段?
- mysql触发器的使用问题
- linux安装最新mysql5.5,my.cnf找不到
- SQL语句修改字段默认值
- 请教大侠一个简单的查表问题
- 卸载了MYSQL,但是MYSQL文件夹删除不了啊,因为进程里还有一个mysqld-nt.exe结束不了,这么办啊?
- 一个表结构成sql语句 ?
- 急!在线等。。。关于win2k下面运行mysql内存不足的原因调查
- 一个mysql分页的问题
- mac mysql Access denied for user 'root'@'localhost' (using password: YES)
- 求教关于CLUSTER中的MANAGEMENT NODE的配置
- postgis的geometry字段问题
+----+---------------------+--------+
| Id | date1 | isPass |
+----+---------------------+--------+
| 1 | 2010-05-17 11:20:28 | 0 |
| 2 | 2010-05-13 14:34:04 | 0 |
| 3 | 2010-05-13 14:34:31 | 0 |
+----+---------------------+--------+
3 rows in set (0.00 sec)mysql> select id,date(date1)=curdate()
-> from `times`;
+----+-----------------------+
| id | date(date1)=curdate() |
+----+-----------------------+
| 1 | 1 |
| 2 | 0 |
| 3 | 0 |
+----+-----------------------+
3 rows in set (0.08 sec)
Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> select * from times;
+----+---------------------+--------+
| Id | date1 | isPass |
+----+---------------------+--------+
| 1 | 2010-05-17 11:20:28 | 1 |
| 2 | 2010-05-13 14:34:04 | 0 |
| 3 | 2010-05-13 14:34:31 | 0 |
+----+---------------------+--------+
3 rows in set (0.00 sec)
curdate()) 今天的日期
date(date1) =curdate() , 如果相等,则返回1,否则返回0