1、查询日期从2003-1-12-2003-2-15的数据如何查询? select * from yourtalbe where to_days(your_date_col)>=to_days('2003-1-12') and to_days(your_date_col)<=to_days('2003-2-15')2、查询一个表中第二十条到第三十条记录? SELECT * FROM yourtable order by id LIMIT 19,11
1、查询日期从2003-1-12-2003-2-15的数据如何查询? select * from yourtalbe where to_days(your_date_col)>=to_days('2003-1-12') and to_days(your_date_col)<=to_days('2003-2-15')2、查询一个表中第二十条到第三十条记录? SELECT * FROM yourtable order by id LIMIT 19,11
select * from yourtalbe where to_days(your_date_col)>=to_days('2003-1-12') and to_days(your_date_col)<=to_days('2003-2-15')2、查询一个表中第二十条到第三十条记录?
SELECT * FROM yourtable order by id LIMIT 19,11
select * from yourtalbe where to_days(your_date_col)>=to_days('2003-1-12') and to_days(your_date_col)<=to_days('2003-2-15')2、查询一个表中第二十条到第三十条记录?
SELECT * FROM yourtable order by id LIMIT 19,11