求sqlserver改写成mysql语句解决办法

求sqlserver改写成mysql语句

Java code

//这个是求pddate与系统时间的天数差select         bookId,bookName,booktypeId,pbName,author,        context,smallImg,bigImg,price,pbdate,        bookStates,    ygcprice ,numfrom bookInfo where num<10 and Datediff(Day, pbdate, Getdate()) >= 15 order by pbdate ,num ascselect  top 5        bookId,bookName,booktypeId,pbName,author,        context,smallImg,bigImg,price,pbdate,        bookStates,    ygcprice ,numfrom bookInfo  where bookStates <> 4 and  booktypeId <> 0and        bookId not in    (select top 0     bookId from bookInfo  where bookStates <> 4 and  booktypeId <> 0    )select  top 2        bookId,bookName,booktypeId,pbName,author,        context,smallImg,bigImg,price,pbdate,        bookStates,    ygcprice ,numfrom bookInfo  where bookStates  = 2 and  booktypeId  = 21and        bookId not in    (select top 0     bookId from bookInfo  where bookStates  = 2 and  booktypeId  = 21    )