sql 教程 - access軟件網(wǎng)-access,access數(shù)據(jù) …

1、SQL教程...............................................................................................................................................12SQL簡介.................................................................

2、...........................................................................12什么是SQL？...............................................................................................................................12SQL能做什么

3、？...........................................................................................................................12SQL是一種標準但是....................................................................................

4、.........................12在您的網(wǎng)站中使用SQL...............................................................................................................12RDBMS................................................................

5、..........................................................................13SQL語法...........................................................................................................................................

6、.14數(shù)據(jù)庫表.........................................................................................................................................14SQL語句.....................................................................

7、..................................................................14重要事項.........................................................................................................................................14SQL語句后面的分

8、號？...............................................................................................................14SQLDML和DDL...............................................................................................

9、........................15SQL語句...........................................................................................................................16SQL語句...........................................................

10、...........................................................16SQL實例......................................................................................................................16SQL實例.............................

11、......................................................................................16在結果集（resultset）中導航...................................................................................................17SQLDISTINCT語句

12、........................................................................................................18SQLDISTINCT語句..................................................................................................18使

13、用DISTINCT關鍵詞...............................................................................................................18SQLWHERE子句.....................................................................................

14、.......................................20WHERE子句................................................................................................................................20使用WHERE子句.................................

15、.....................................................................................20Person:..............................................................................................................................

16、............30刪除某行.........................................................................................................................................30刪除所有行..........................................................

17、...........................................................................30SQLTOP子句..................................................................................................................................31TOP

18、子句.......................................................................................................................................31MySQL和acle中的SQLTOP是等價的......................................................31原始的

19、表(用在例子中的)：........................................................................................................31SQLTOP實例................................................................................................

20、..............................32SQLTOPPERCENT實例.........................................................................................................32SQLLIKE操作符........................................................

21、......................................................................33LIKE操作符..................................................................................................................................33原始的表(用在例子

22、中的)：........................................................................................................33LIKE操作符實例.....................................................................................................

23、.....................33SQL通配符........................................................................................................................................35SQL通配符...............................................

24、....................................................................................35原始的表(用在例子中的)：........................................................................................................35使用%通配符.........

25、.....................................................................................................................35使用_通配符...............................................................................................

26、................................36使用[list]通配符................................................................................................................37SQLIN操作符.....................................................

27、..............................................................................38IN操作符.......................................................................................................................................

28、38原始的表(在實例中使用：)........................................................................................................38IN操作符實例............................................................................................