mysql> LOAD DATA LOCAL INFILE '/path/pet.txt' INTO TABLE pet; Also, with INSERT , you can insert NULL directly to represent a missing value. You do not .