"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
mysql>fields terminated by ',' enclosed by '"'
mysql>lines terminated by '
';