distal-attribute
distal-attribute
distal-attribute
distal-attribute

Import selected rows depending on condition

User, date Message
Written by SanRoQuin
1 year ago
Category: Import/Export
1 posts since Tue, 18 Jun 13
Hi,

I have huge csv files from which only certain amount of rows are useful for me. Is it possible to import only some rows according to a predefined criteria? the criteria would be the value of a/some column/s on each row.

for example: only load the rows where the value of the column3 <> 0.

The import menu doesn't offer such an option and I've tried the IGNORE command inside the LOAD but I don't really know how to use it

Thanks in advance
Written by ansgar
1 year ago
4940 posts since Fri, 07 Apr 06
No, there is no such a feature, neither in HeidiSQL nor in MySQL's own LOAD DATA command.

I would simply import everything and delete unwanted rows afterwards.
 

Please login to leave a reply, or register at first.