LOAD DATA LOCAL INFILE '/path to pet txt/pet.txt' INTO TABLE pet;

pet.txt

INSERT

When you want to add new records one at a time, the INSERT statement is useful.

INSERT INTO pet VALUE ('Puffball','Daiane','hamster','f','1999-03-30',NULL);