随笔分类 -  SQL备忘录

一些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,Course 阅读全文
posted @ 2012-12-02 10:41 Guilyn 阅读(123) 评论(0) 推荐(0)