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);
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);