I was wondering whether it was possible to make and AUTO_INCREMENT
field instead of always adding 1 and starting at zero, into a SEQUENCE
type field so that it is say a 10 digit integer and numbers are created
according to the SEQUENCE.
thanks
Graham
Hi everyone,
I am currently trying to run the following command:
LOAD DATA INFILE D:\mysql\sql\CountryData.txt
INTO TABLE cou
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\r\n'
(id, country);
Example data in file is:
country, id
-Original Message-
From: Jay Blanchard [mailto:[EMAIL PROTECTED]
Sent: 15 December 2003 14:03
To: Graham Little; [EMAIL PROTECTED]
Subject: RE: SEQUENCES
[snip]
I was wondering whether it was possible to make and AUTO_INCREMENT
field instead of always adding 1 and starting at zero
Hi Chris,
Thanks for your help, i will find another way around it.
Graham
-Original Message-
From: Chris Nolan [mailto:[EMAIL PROTECTED]
Sent: 15 December 2003 14:13
To: Graham Little
Cc: '[EMAIL PROTECTED]'
Subject: Re: SEQUENCES
Hi,
As far as I know, definitely not. However, you
That is brilliant thank you. I was doing it the wrong way
around when i was naming the fields.
Thank you for your help
graham
-Original Message-
From: Tobias Asplund [mailto:[EMAIL PROTECTED]
Sent: 15 December 2003 14:46
To: Graham Little
Cc: '[EMAIL PROTECTED]'
Subject: Re: LOAD DATA