小弟写了一个应用,用C来访问mysql时出现了问题,如下:
sprintf(buff, "select * from selectFood where selectFoodTime > = '2006-6-20 00:00:00' \
&& selectFoodTime <= '2009-1-01 23:59:59' \
order by tableID desc");
总是报错:Segmentation fault 。一直找不到,不知道是什么原因。求高人指点以下啊!多谢!等待中...
sprintf(buff, "select * from selectFood where selectFoodTime > = '2006-6-20 00:00:00' \
&& selectFoodTime <= '2009-1-01 23:59:59' \
order by tableID desc");
总是报错:Segmentation fault 。一直找不到,不知道是什么原因。求高人指点以下啊!多谢!等待中...
select ..
from ..
where ..
group by ..
having ..
order by ..
selectFoodTime between('2006-6-20 00:00:00','2009-1-01 23:59:59')
order by tableID desc;
==>
select tableID from selectFood where
selectFoodTime between '2006-6-20 00:00:00' and '2009-1-01 23:59:59'
order by tableID desc;