Import selected rows depending on condition

SanRoQuin posted 4 years ago in Import/Export

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
ansgar posted 4 years ago
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.