MySQL导入txt文件

例如：andy.txt文件内容如下

"Flufy","Harold","cat","f","1993-2-4"

"claws","Gwen","cat","m","1994-3-17"

"Brower","Diane","dog","m","1994-3-17","1999-3-17"

"Whistler","Gwen","bird",,"1994-3-17"

"Slim","Benny","snake","m","1996-3-17"

mysql>load data local infile '/path/andy.txt' into table pet fields terminated by ',' enclosed by '"' lines terminated by '\r\n';