Le jeudi 11 d�cembre 2003, Martin Cordova S. a �crit...
bonjour,
> Can someone please post a link to a sample data file formatted for the
> DATALOAD command (using a field separator - if possible).
CREATE TABLE individus (
IdAnimal SMALLINT DEFAULT SERIAL PRIMARY KEY,
Boucle VARCHAR(5) DEFAULT NULL,
Tatouage VARCHAR(5) NOT NULL,
Naisseur VARCHAR(8) NOT NULL,
Sexe CHAR NOT NULL DEFAULT 'f' CONSTRAINT ct_Sexe CHECK Sexe IN ('f',
'm'),
Entree DATE DEFAULT NULL,
Sortie DATE DEFAULT NULL,
FilleDe SMALLINT DEFAULT NULL,
Tiptag VARCHAR(5) DEFAULT NULL,
CauseEntree VARCHAR(3) NOT NULL CONSTRAINT ct_CauseEntree CHECK
CauseEntree LIKE 'E%',
CauseSortie VARCHAR(3) NOT NULL CONSTRAINT ct_CauseSortie CHECK
CauseSortie LIKE 'S%',
Cornes CHAR NOT NULL DEFAULT 'o' CONSTRAINT ct_Cornes CHECK Cornes IN
('o', 'n'),
Caractere VARCHAR(40) NOT NULL,
FOREIGN KEY ct_fk_CauseEntree (CauseEntree) REFERENCES mouvements
(idmouvement),
FOREIGN KEY ct_fk_CauseSortie (CauseSortie) REFERENCES mouvements
(idmouvement)
)
//
SET COMPRESSED '/ //'
//
DATALOAD TABLE JM.INDIVIDUS
IdAnimal 1
Boucle 2 DEFAULT NULL
Tatouage 3
Naisseur 4
Sexe 5
Entree 6 DEFAULT NULL
Sortie 7 DEFAULT NULL
FilleDe 8 DEFAULT NULL
Tiptag 9 DEFAULT NULL
CauseEntree 10
CauseSortie 11
Cornes 12
Caractere 13
INFILE '/home/jm/sapdb/data/TROUPEAU/individus.txt'
NULL '?'
//
ALTER TABLE INDIVIDUS FOREIGN KEY ct_fk_FilleDe (FilleDe) REFERENCES individus
(IdAnimal)
field separator is Tab, no field delimiter.
--
jean-michel
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
