【问题】 存储数据文件的student.txt文本中存储的内容形式如下:“2012110708”,19, “张三”“2012110710”,20, “李四”将上述的数据导入到数据表:学生(学号,姓名,年龄),正确的命令应为( )A. load data infile .student.txt. into table 学生 fields terminated by .,. optionally enclosed by .". lines terminated by .\n.;B. load data infile
存储数据文件的student.txt文本中存储的内容形式如下:“2012110708”,19, “张三”“2012110710”,20, “李四”将上述的数据导入到数据表:学生(学号,姓名,年龄),正确的命令应为( )A. load data infile .student.txt. into table 学生 fields terminated by .,. optionally enclosed by .". lines terminated by .\n.;B. load data infile .student.txt. into学生 fields terminated by .,. optionally enclosed by .". lines terminated by .\n.;C. load data infile .student.txt. into table 学生(学号,年龄,姓名) fields terminated by .,. optionally enclosed by .". lines terminated by .\n.;D. load data infile .student.txt. into 学生(学号,年龄,姓名) fields terminated by .,. optionally enclosed by .". lines terminated by .\n.;
正确答案:C
题目解析:本题出自河南大学,国家开放大学数据库运维,由丰阳塔题库搜集整理。