CODEWITHSUNDEEP
mysqlsqladaption
anonymous
anonymous

Reputation: 244

Equivalent of SET with LOAD DATA INFILE for MySQL 4.1?

I'd to use LOAD DATA INFILE to load a .txt file.

The file contains data for only some of the columns, so I'd like to use SET to specify the value of one of the columns not included in the file.

Here's the syntax I'd use:

LOAD DATA LOCAL INFILE 'file.txt'
INTO TABLE some_table
FIELDS TERMINATED BY ','
(column1, column2, column3)
SET column4 = 100

The problem is that SET is only an option in MySQL 5.0; unfortunately, I'm stuck using MySQL 4.1.

Is there an equivalent way to accomplish this using v. 4.1?

Upvotes: 1

Views: 311

Answers (1)

fancyPants
fancyPants

Reputation: 51928

Too long for a comment, so posting as answer.

I never had to work with versions prior 5.0, so just asking have you tried

LOAD DATA LOCAL INFILE 'file.txt'
INTO TABLE some_table
FIELDS TERMINATED BY ','
(column1, column2, column3, 400)

or omit column4 

LOAD DATA LOCAL INFILE 'file.txt'
INTO TABLE some_table
FIELDS TERMINATED BY ','
(column1, column2, column3)

and then 

UPDATE some_table SET column4 = 400;

? Column4 must have a default value for this. In case it doesn't have, you can easily add one with an ALTER TABLE statement.

Upvotes: 0

Related Questions