K_Sqllite3专题

编程算法

  • 创建表

    1
    2
    3
    4
    5
    6
    7
    8
    9
    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 );

  • 查看建表信息

    1
    .schema PEOPLE

  • 查看表

    1
    .tables

  • 获取数据

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

  • 删除表

    1
    DROP TABLE PEOPLE;

  • 向指定表中添加数据行

    1
    2
    3
    4
    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 );

  • 在制定表中删除数据行

    1
    DELETE FROM PEOPLE WHERE ID = 2;

  • 终端查找

    1
    find / -name sqlite3