查詢實(shí)例：
1.select * from asset,class where asset.sum=class.class_id
2.select * from asset where name like '%電%' order by id desc
3.select * from asset where name=''
4.select * from asset where name<>''
5.select * from asset where sum is not null
6.select * from asset where sum is null 'null不等于''
7.select * from asset where dat>#2001-7-20#
8.select max(sum) as 最大值,min(sum) as 最小值,sum(sum) as 總和,avg(sum) as 平均值,count(sum) as 記錄數(shù),count(*) as 總記錄數(shù) from asset
9.select * from asset where name like '__' '找兩個字符的記錄
10.select * from asset where name like '%電%' and name like '%腦%'
增加，修改，刪除實(shí)例：
1.insert into asset(name,sum,dat,pass) values('電器',24,#2001-8-8#,1)
2.update asset set pass=0 where pass=1
3.delete from asset where name='電視' and pass=true
創(chuàng)建,刪除,增加字段實(shí)例：
1.CREATE TABLE test (數(shù)字 int NOT NULL,文本 text (250),日期 datetime,備注 memo,是否 bit,primary key(數(shù)字))
2.DROP TABLE test '刪除表
3.ALTER TABLE test ADD sum int,tt text (50) '增加字段sum和tt