K_Sqllite3专题

• SQLite 教程 | 菜鸟教程

• 创建表

  CREATE TABLE PEOPLE(
   ...> ID INT PRIMARY KEY NOT NULL,
   ...> NAME TEXT NOT NULL,
   ...> AGE INT NOT NULL,
   ...> ADDRESS CHAR(50),
   ...> SALARY REAL
   ...> );
  
  CREATE TABLE PEOPLE(ID INT PRIMARY KEY NOT NULL, NAME TEXT NOT NULL, AGE INT NOT NULL, ADDRESS CHAR(50), SALARY REAL );

• 查看建表信息

  .schema PEOPLE

• 查看表

  .tables

• 获取数据

  SELECT * FROM table_name;
  SELECT * FROM COMPANY ORDER BY SALARY ASC;

• 删除表

  DROP TABLE PEOPLE;

• 向指定表中添加数据行

  INSERT INTO PEOPLE (ID,NAME,AGE,ADDRESS,SALARY) VALUES (1, 'AAA', 22, 'MeiGuo', 4852.00 );
  INSERT INTO PEOPLE (ID,NAME,AGE,ADDRESS,SALARY) VALUES (2, 'BBB', 25, 'YingGuo', 4856.00 );
  INSERT INTO PEOPLE (ID,NAME,AGE,ADDRESS,SALARY) VALUES (3, 'CCC', 24, 'DeGuo', 4850.00 );
  INSERT INTO PEOPLE (ID,NAME,AGE,ADDRESS,SALARY) VALUES (4, 'DDD', 23, 'HanGuo', 4854.00 );

• 在制定表中删除数据行

  DELETE FROM PEOPLE WHERE ID = 2;

• 终端查找

  find / -name sqlite3