【SQL开源代码栏目提醒】:网学会员在SQL开源代码频道为大家收集整理了学生信息管理系统示例数据的导入.sql提供大家参考,希望对大家有所帮助!
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;