'SQLite'에 해당되는 글 1건

  1. 2010.10.23 SQLite Query Syntax (1)

SQL As Understood By SQLite

SQLite understands most of the standard SQL language. But it does omit some features while at the same time adding a few features of its own. This document attempts to describe precisely what parts of the SQL language SQLite does and does not support. A list of SQL keywords is also provided. The SQL language syntax is described by syntax diagrams.

The following syntax documentation topics are available:

The routines sqlite3_prepare_v2(), sqlite3_prepare(), sqlite3_prepare16(), sqlite3_prepare16_v2(), sqlite3_exec(), and sqlite3_get_table() accept an SQL statement list (sql-stmt-list) which is a semicolon-separated list of statements.


syntax diagram sql-stmt-list

Each SQL statement in the statement list is an instance of the following:


syntax diagram sql-stmt

[출처 : http://www.sqlite.org/lang.html]

'TIP & TALK > Linux' 카테고리의 다른 글

How to run a shell script from a Perl program?  (0) 2011.02.18
SSH login without password  (0) 2011.01.20
SQLite Query Syntax  (1) 2010.10.23
missing sentinel in function call  (1) 2010.10.18
Ubuntu NTFS HDD or Partitionnig Problem  (0) 2010.07.16
Ubuntu 파티션 관리  (0) 2010.07.16
Posted by rookiejava