load data infile语句有关问题

load data infile语句问题

导入数据语句如下：

load data infile ‘d:/userDesc.txt’ into table test.user(uname,num,deptNum) terminated by ‘,’ enclosed by ‘\” lines terminated by ‘\r\n’;

报错如下：

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that

corresponds to your MySQL server version for the right syntax to use near ‘termi

nated by ‘,’ enclosed by ‘\” lines terminated by ‘\r\n” at line 1

load data infile ‘d:/userDesc.txt’ into table test.user(uname,num,deptNum) terminated by ‘,’ enclosed by ‘”‘ lines terminated by ‘\r\n’;

报错同上，大虾赐教

load data infile ‘d:/userDesc.txt’ into table test.user FIELDS terminated by ‘,’ enclosed by ‘\” lines terminated by ‘\r\n’ (uname,num,deptNum);