using AUTO_INCREMENT with LOAD DATA INFILE
Posted: Sat May 29, 2004 1:37 pm
Hello
I am using LOAD DATA INFILE to load data into a table.
This is how the table is defined:
CREATE TABLE people (
ID INT UNSIGNED NOT NULL AUTO_INCREMENT,
Name VARCHAR(255) NOT NULL,
Address VARCHAR(255) NOT NULL,
PRIMARY KEY (ID)
) ENGINE=MYISAM DEFAULT CHARSET=latin1;
I have 2 questions:
1) What value should be written in the file to represent a placeholder for the ID (it is an AUTO_INCREMENT attribute)?
2) Do I need to enclose strings (Name & Address attributes) with quotes?
thanks
I am using LOAD DATA INFILE to load data into a table.
This is how the table is defined:
CREATE TABLE people (
ID INT UNSIGNED NOT NULL AUTO_INCREMENT,
Name VARCHAR(255) NOT NULL,
Address VARCHAR(255) NOT NULL,
PRIMARY KEY (ID)
) ENGINE=MYISAM DEFAULT CHARSET=latin1;
I have 2 questions:
1) What value should be written in the file to represent a placeholder for the ID (it is an AUTO_INCREMENT attribute)?
2) Do I need to enclose strings (Name & Address attributes) with quotes?
thanks