出自:国家开放大学数据库运维
存储数据文件的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.;