存储数据文件的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.;
|
