CODEWITHSUNDEEP
mysql
Guilherme Jardim Duarte
Guilherme Jardim Duarte

Reputation: 524

How to replace a Column simultaneously with LOAD INFILE in MySQL

Suppose we have table with a DECIMAL column with values, for example: 128.98, 283.98, 21.20.

I want to import some CSV Files to this table. However, in the columns of these files, I have values like 235,69, 23,23, with comma instead of points.

I know I can REPLACE that column, but is there some way of doing that before LOAD INFILE?

Upvotes: 0

Views: 48

Answers (1)

BK435
BK435

Reputation: 3176

I do not believe you can simultaneously replace that column and load the data. Looks like you will have to do multiple steps to get the results you want.

Load the data first into a raw table using the LOAD INFILE command. This table can be identical to the main table. You can use the Create Table like command to create the table.

Process the data (i.e. change the comma to a . where applicable) in the raw table.

select the data from the raw table and insert into main table either with row by row processing or bulk insert.

This can all be done in a stored procedure (SP) or by a 3rd party script written in python, php, etc...

If you want to know more about SP's in Mysql, Here is a useful link.

Upvotes: 1

Related Questions