Fluff 1995-05-15 litter 4kittens,3female,1male Buffy 1993-06-23 litter 5puppies,2female,3male Buffy 1994-06-19 litter 3puppies,3female Chirpy 1999-03-21 vet needed beak straightened Slim 1997-08-03 vet broken rib Bowser 1991-10-12 kennel null Fang 1991-10-12 kennel null Fang 1998-08-28 birthday Gave him a new chew toy Claws 1998-03-17 birthday Gave him a new flea collar Whistler 1998-12-09 birthday First birthday
字段以TAB为delimeter
== 思想重于技巧 ==
load data infile 'your file path' into table yourtablename fields terminated by '你的字段间隔'
Buffy 1993-06-23 litter 5puppies,2female,3male
Buffy 1994-06-19 litter 3puppies,3female
Chirpy 1999-03-21 vet needed beak straightened
Slim 1997-08-03 vet broken rib
Bowser 1991-10-12 kennel null
Fang 1991-10-12 kennel null
Fang 1998-08-28 birthday Gave him a new chew toy
Claws 1998-03-17 birthday Gave him a new flea collar
Whistler 1998-12-09 birthday First birthday