题目内容
来源: 《数据库运维》历届试题 课程号:04412
[多选]

消费者表customers(cid,cname,caddress,cgender),cid是主键使用select…intooutfile语句导出customers表中消费者的地址为北京的数据,导出的字段中不包含地址,并且指定数据导出到C盘的BACKUP目录下一个名为backupfile.txt的文件中,要求字段值如果是字符则用双引号标注,字段值之间用逗号隔开,每行以问好为结束标志。正确的语句是()。

A.SELECTcid,cname,cgenderFROMcustomersWHEREcaddress='北京'INTOOUTFILE‘C:/BACKUP/backupfile.txt'FIELDSTERMINATEDBY‘,'OPTIONALLYENCLOSEDBY‘”'LINESTERMINATEDBY‘?';B.SELECTcid,cname,cgenderFROMcustomersWHEREcaddress='北京'INTOOUTFILE‘C:/BACKUP/backupfile.txt'FIELDSTERMINATEDBY‘,'ENCLOSEDBY‘”'LINESTERMINATEDBY‘?';C.SELECTcid,cname,cgenderFROMcustomersWHEREcaddresslike'%北京%'INTOOUTFILE‘C:/BACKUP/backupfile.txt'FIELDSTERMINATEDBY‘,'OPTIONALLYENCLOSEDBY‘”'LINESTERMINATEDBY‘?';D.SELECTcid,cname,cgenderFROMcustomersWHEREcaddress='北京'INTOOUTFILE‘C:/BACKUP/backupfile.txt'FIELDSTERMINATEDBY‘,'ENCLOSEDBY‘”'LINESTERMINATEDBY‘?';
查看答案
《数据库运维》其他资源