SQLite学习【一】

SQLite学习.sql

--创建数据库(数据库名可以是任何名字，文件类型始终为sqlite类型)
sqlite3 test.sqlite
sqlite3 other.db
sqlite3 db.sqlite3

--创建数据表 增删改查 SQLite

CREATE TABLE DEPARTMENT(
   ID INT PRIMARY KEY      NOT NULL,
   DEPT           CHAR(50) NOT NULL,
   EMP_ID         INT      NOT NULL
);
CREATE TABLE  Test(
   ID INT PRIMARY KEY     NOT NULL,
   NAME           TEXT    NOT NULL,
   AGE            INT     NOT NULL,
   ADDRESS        CHAR(50),
   SALARY         REAL
);

SELECT * FROM sqlite_master WHERE type = 'table';

DROP TABLE  DEPARTMENT;

SELECT * FROM sqlite_master WHERE type = 'table';

--增

INSERT INTO `Test` (ID, NAME, AGE, ADDRESS, SALARY) VALUES (1,'测试人员',35,'东北那旮瘩',5000);

INSERT INTO `Test` (ID, NAME, AGE, ADDRESS, SALARY)
VALUES (2,'测试人员',35,'东北那旮瘩',10000);

SELECT * from Test ;
--删
DELETE from `Test` where ID='1';
SELECT * from Test ;

--改
update `Test` set Name ='测试人员2' where ID=2;
SELECT * from `Test`;

DROP TABLE Test;
SELECT * FROM sqlite_master WHERE type = 'table';