常用的SQL（structured query language 結(jié)構(gòu)化查詢語言）語句

1，創(chuàng)建表

CREATE 創(chuàng)建

TABLE 表

PRIMARYKEY 主鍵,唯一標示符；

AUTOINCREMENT 自動增長

NOTNULL 非空

UNIQUE 唯一的

CREATE TABLE Teacher1 (teacher_id INTEGER PRIMARYKEY AUTOINCREMENT NOT NULL UNIQUE, teacher_name TEXT, teacher_sex BOOL EAN)

CREATE TABLE Teacher2 (teacher_id INTEGER PRIMARYKEY AUTOINCREMENT,? teacher_name TEXT, teacher_sex BOOL EAN)

CREATE TABLEif not exists student (id int primarykey not null,name text,age int)

2, 刪除表

DROP 丟棄 扔到

DROP TABLE Teacher1

3,給表添加列

ALTER 改變 修改

ALTER TABLE Teacher2 ADD teacher_age INT EGER

4,插入數(shù)據(jù)

INSERT INTO Teacher VALUES(1 ,'zhangsan' ,1)

INSERT INTO Students (name ,sex) VALUES ('zhangsan' ,0)

5,查詢數(shù)據(jù)

SELECT 查詢

* 全部

FROM

SELECT * FROM Students

SELECT * FROM Students WHERE number<10

SELECT * FROM Students WHERE number<10 OR sex=1

SELECT * FROM Students WHERE number<10 AND number>5

like 匹配

SELECT * FROM Students WHERE name like '%zhang%'

SELECT * FROM Students WHERE name like 'zhang_'

LIMIT 限制

從第六條開始往后的15條

SELECT * FROM Students LIMIT 5,15

6,修改數(shù)據(jù)

UPDATE 更新

set 設置

UPDATE Students set name = 'lisi' ,sex = 1 where number < 10 AND number>5

7,刪除數(shù)據(jù)

DELETE 刪除

DELETE FROM Students WHERE number > 25

delete from people_test where people_id <> 3

等價于

delete from people_test where people_id != 3