各种常用sql

insert into tab1 (name,num) values('asas',100)

 

delete from tab1 where name='aaa'

 

update tab1 set name='1212', num=1212 where ID=2

 

SELECT Company, OrderNumber FROM Orders ORDER BY Company DESC, OrderNumber ASC

Select ID From cyclopedia limit 90000,1

where date1<#2008-1-20# and date2>#2007-8-30#
where between '2008-1-1' and '2009-1-1' 
where year(fielddate)=2008 and month(fielddate)=12

SELECT * FROM book WHERE Name LIKE '%%%s%%' ORDER BY %s %s