I am pretty new to mySQL and I have been trying to load my .sql document to FireFox's SQLite Manager I keep getting errors each time I do. Can someone help me.
create database Adoptees;
use Adoptees;
/*Creating the Tables */ Create table Dogs(animalId text, name text, adoptLoc text, currentFoster text, breed text, specfeat text, gender text, spayNeu text, age text, weightPounds int); Create table Cats(animalId text, name text, adoptLoc text, currentFoster text, breed text, gender text, spayNeu text, age text, weightPounds int); Create table Rabbits(animalId text, name text, adoptLoc text, currentFoster text, breed text, gender text, spayNeu text, age text, weightPounds int); Create table Small_Rodents(animalId text, name text, adoptLoc text, currentFoster text, breed text, gender text, spayNeu text, age text, weightPounds int);
LOAD DATA INFILE 'dog.csv' INTO TABLE Dogs FIELDS TERMINATED BY ',' ENCLOSED BY ' " ' LINES TERMINATED BY '\r\n'; LOAD DATA INFILE 'cats.csv' INTO TABLE Cats FIELDS TERMINATED BY ',' ENCLOSED BY ' " ' LINES TERMINATED BY '\r\n'; LOAD DATA INFILE 'rabbits.csv' INTO TABLE Rabbits FIELDS TERMINATED BY ',' ENCLOSED BY ' " ' LINES TERMINATED BY '\r\n'; LOAD DATA INFILE 'smallRodents.csv' INTO TABLE Small_Rodents FIELDS TERMINATED BY ',' ENCLOSED BY ' " ' LINES TERMINATED BY '\r\n';
Aucun commentaire:
Enregistrer un commentaire