SQLÓï¾ä´óÈ« ÏÂÔØ±¾ÎÄ

²åÈ룺insert into table1(field1,field2) values(value1,value2) ɾ³ý£ºdelete from table1 where ·¶Î§

¸üУºupdate table1 set field1=value1 where ·¶Î§

²éÕÒ£ºselect * from table1 where field1 like ¡¯%value1%¡¯ £¨ËùÓаüº¬¡®value1¡¯Õâ¸öģʽµÄ×Ö·û´®£©---likeµÄÓï·¨ºÜ¾«Ã²é×ÊÁÏ!

ÅÅÐò£ºselect * from table1 order by field1,field2 [desc] ×ÜÊý£ºselect count(*) as totalcount from table1 ÇóºÍ£ºselect sum(field1) as sumvalue from table1 ƽ¾ù£ºselect avg(field1) as avgvalue from table1 ×î´ó£ºselect max(field1) as maxvalue from table1

×îС£ºselect min(field1) as minvalue from table1[separator]