摘要： 创建【考试计划表】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,Course 阅读全文