vendredi 22 avril 2016

Issue with loading to SQLite

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