一些SQLite语句

创建【考试计划表】

CREATE TABLE jihua (
    "ProID" TEXT,
    "ProName" TEXT,
    "CourseID" TEXT,
    "CourseName" TEXT,
    "TestDate" TEXT
)

从【考试计划表】中新建【专业表】

create table pro as select distinct ProID,ProName from jihua;

新建【计算机专业视图】

create view jsj as select distinct CourseID,CourseName from jihua where ProName='计算机';

新建【计算机相关专业视图】

create view jsjs as select distinct ProID,ProName from jihua where ProName like '%计算机%';