SQLite常用SQL命令

前端之家收集整理的这篇文章主要介绍了SQLite常用SQL命令前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。

~~~~~关于sqlite的一些常用的sql命令~~~~~~~~~~~

创建数据库表:

CREATE TABLE IF NOT EXISTS

table-name ( column-def1,column-def2)

table-name:指的是数据库表的名称

column-def:指的是表的列定义

其中 column-def又分为: column-name type-name column-constraint

type-name:常用的有 INTEGER / VARCHAR

其中column-constraint:常用的形式有 PRIMARY KEY

--------------------------------------------------------------------

向现有的数据库表格中插入记录:

INSERT INTO

table-name (column-name1,column-name2) VALUES ( expr1,expr2)

------------------------------------------------------------------------

从现有的数据库删除记录:

DELETE FROM

squalified-table-name WHERE expr

-------------------------------------------------------------------------

删除数据库的表:

DROP TABLE IF EXISTS table-name

说明:The DROP TABLE statement removes a table added with the CREATE TABLE statement. The name specified is the table name. The dropped table is completely removed from the database schema and the disk file. The table can not be recovered. All indices and triggers associated with the table are also deleted.

------------------------------------------------------------------------------

在现有的数据库表中进行修改记录:

UPDATE qualified-table-name SET column-name = expr WHERE expr

说明:The UPDATE statement is used to change the value of columns in selected rows of a table. Each assignment in an UPDATE specifies a column name to the left of the equals sign and an arbitrary expression to the right. The expressions may use the values of other columns. All expressions are evaluated before any assignments are made. A WHERE clause can be used to restrict which rows are updated.

------------------------------------------------------------------------------

从现有的表格中选择符合条件的记录:

SELECT (DISTINCT/ALL) FROM join-source WHERE expr GROUP-BY ordering-term HAING expr ORDER BY ordering-term

猜你在找的Sqlite相关文章