2009年3月4日 星期三

SQLite3 之 SQL 語法

SQLite 3 所支援之SQL 語法:

 

l          aggregate functions

l          ALTER TABLE

l          ANALYZE

l          ATTACH DATABASE

l          BEGIN TRANSACTION

l          comment

l          COMMIT TRANSACTION

l          core functions

l          CREATE INDEX

l          CREATE TABLE

l          CREATE TRIGGER

l          CREATE VIEW

l          CREATE VIRTUAL TABLE

l          date and time functions

l          DELETE

l          DETACH DATABASE

l          DROP INDEX

l          DROP TABLE

l          DROP TRIGGER

l          DROP VIEW

l          END TRANSACTION

l          EXPLAIN

l          expression

l          INDEXED BY

l          INSERT

l          keywords

l          ON CONFLICT clause

l          PRAGMA

l          REINDEX

l          RELEASE SAVEPOINT

l          REPLACE

l          ROLLBACK TRANSACTION

l          SAVEPOINT

l          SELECT

l          UPDATE

l          VACUUM


沒有留言:

張貼留言