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
