问一个MySQL时间段查询问题

flyingzf

表里有一个字段 "datetime" 格式为 "2010-07-06 12:35:23"

如何查询当月记录和某个时间段的记录 例如 从 2010-01-01 00:00:00"  至 2010-07-06 23:59:59"的记录
非常感谢！

ruochen

1. root@localhost:test 10:23:54>select * from t_datetime;
   
2. +---+---------------------+
   
3. | a | b                   |
   
4. +---+---------------------+
   
5. | 1 | 2010-07-07 10:20:56 |
   
6. | 2 | 2010-07-07 10:21:02 |
   
7. | 5 | 2010-07-07 10:21:48 |
   
8. | 4 | 2010-07-07 10:21:02 |
   
9. +---+---------------------+
   
10. 4 rows in set (0.00 sec)
    
11. 
    
12. root@localhost:test 10:24:00>select * from t_datetime where b between '2010-07-07 10:21:02' and '2010-07-07 10:21:48';
    
13. +---+---------------------+
    
14. | a | b                   |
    
15. +---+---------------------+
    
16. | 2 | 2010-07-07 10:21:02 |
    
17. | 5 | 2010-07-07 10:21:48 |
    
18. | 4 | 2010-07-07 10:21:02 |
    
19. +---+---------------------+
    
20. 3 rows in set (0.00 sec)
    
21. 
    
22. root@localhost:test 10:24:03>select * from t_datetime where b >='2010-07-07 10:21:02' and b<='2010-07-07 10:21:48';
    
23. +---+---------------------+
    
24. | a | b                   |
    
25. +---+---------------------+
    
26. | 2 | 2010-07-07 10:21:02 |
    
27. | 5 | 2010-07-07 10:21:48 |
    
28. | 4 | 2010-07-07 10:21:02 |
    
29. +---+---------------------+
    
30. 3 rows in set (0.00 sec)
    
31. 
    
32. root@localhost:test 10:24:14>show create table t_datetime\G;
    
33. *************************** 1. row ***************************
    
34.        Table: t_datetime
    
35. Create Table: CREATE TABLE `t_datetime` (
    
36.   `a` int(11) NOT NULL auto_increment,
    
37.   `b` datetime default NULL,
    
38.   PRIMARY KEY  (`a`)
    
39. ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8
    
40. 1 row in set (0.00 sec)
    
41. 
    

复制代码