学生信息管理系统示例数据的导入.sql

来自「学生信息管理系统简单实现 可以简单得实现现阶段学生信息得增加 修改 删除 查看」· SQL 代码 · 共 30 行

LOAD DATA LOCAL INFILE 'c:/college_info.txt' INTO TABLE college_info;

LOAD DATA LOCAL INFILE 'c:/teach_info.txt' INTO TABLE teach_info;

LOAD DATA LOCAL INFILE 'c:/course_info.txt' INTO TABLE course_info;

LOAD DATA LOCAL INFILE 'c:/student_info.txt' INTO TABLE student_info;

LOAD DATA LOCAL INFILE 'c:/messege_info.txt' INTO TABLE messege_info;

LOAD DATA LOCAL INFILE 'c:/comment_info.txt' INTO TABLE comment_info;

LOAD DATA LOCAL INFILE 'c:/news_info.txt' INTO TABLE news_info;

LOAD DATA LOCAL INFILE 'c:/messege_answer_info.txt' INTO TABLE messege_answer_info;

LOAD DATA LOCAL INFILE 'c:/stu_score.txt' INTO TABLE stu_score;

LOAD DATA LOCAL INFILE 'c:/required_course_scheme.txt' INTO TABLE required_course_scheme;

LOAD DATA LOCAL INFILE 'c:/selective_course_scheme.txt' INTO TABLE selective_course_scheme;