I have a table in my mysql db. This is my table.
material sorg f_date t_date
2000012 2100 2016-05-01 2016-05-30
2000013 2100 2016-05-01 2016-05-21
2000021 2200 2016-05-01 2016-05-30
2000151 2100 2016-05-01 2016-05-15
2000336 2300 2016-05-01 2016-05-04
2000366 2300 2016-05-01 2016-05-24
2000451 2400 2016-05-01 2016-05-30
2000493 2200 2016-05-01 2016-05-11
I want to get material between two given date(f_date and t_date).
This is my query...
SELECT tbl_fast_goods.material from tbl_fast_goods WHERE f_date >= '2016-05-23' AND t_date <= '2016-05-29'
The output should be.
2000012, 2000021, 2000366, 2000451
But the problem is no output is given.
I think you want this, you just mistook the column.
MySQL 5.6 Schema Setup:
CREATE TABLE tbl
(`id` int, `user_id` int, `weather_type` varchar(5))
;
INSERT INTO tbl
(`id`, `user_id`, `weather_type`)
VALUES
(1, 12, 'cloud'),
(2, 12, 'rain'),
(3, 12, 'clear'),
(4, 14, 'rain'),
(5, 15, 'clear')
;
CREATE TABLE tbl_fast_goods
(`material` int, `sorg` int, `f_date` datetime, `t_date` datetime)
;
INSERT INTO tbl_fast_goods
(`material`, `sorg`, `f_date`, `t_date`)
VALUES
(2000012, 2100, '2016-05-01 00:00:00', '2016-05-30 00:00:00'),
(2000013, 2100, '2016-05-01 00:00:00', '2016-05-21 00:00:00'),
(2000021, 2200, '2016-05-01 00:00:00', '2016-05-30 00:00:00'),
(2000151, 2100, '2016-05-01 00:00:00', '2016-05-15 00:00:00'),
(2000336, 2300, '2016-05-01 00:00:00', '2016-05-04 00:00:00'),
(2000366, 2300, '2016-05-01 00:00:00', '2016-05-24 00:00:00'),
(2000451, 2400, '2016-05-01 00:00:00', '2016-05-30 00:00:00'),
(2000493, 2200, '2016-05-01 00:00:00', '2016-05-11 00:00:00')
;
Query 1:
SELECT tbl_fast_goods.material
from tbl_fast_goods
WHERE t_date >= '2016-05-23' AND f_date <= '2016-05-29'
| material |
|----------|
| 2000012 |
| 2000021 |
| 2000366 |
| 2000451 |
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments