Bug #27136 Load Data Infile - limit enhancement.
Submitted: 14 Mar 2007 15:32 Modified: 30 Sep 2009 11:48
Reporter: Matthew Miller Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: General Severity:S4 (Feature request)
Version:All Versions OS:Novell NetWare (Netware)
Assigned to: CPU Architecture:Any

[14 Mar 2007 15:32] Matthew Miller 
Description:
It would be extremely helpful to include SQL 'limit' as part of the 'load data infile'  syntax.  Ignore lines (offset) is already included, however, this would be more useful with the addition of a limit so that large outfiles could be created and then divided into multiple infile statements easily.  This would be especially useful since infile becomes so slow over large files; if they are not broke up.

How to repeat:
It would be extremely helpful to include SQL 'limit' as part of the 'load data infile'  syntax.  Ignore lines (offset) is already included, however, this would be more useful with the addition of a limit so that large outfiles could be created and then divided into multiple infile statements easily.  This would be especially useful since infile becomes so slow over large files; if they are not broke up.
[14 Mar 2007 17:08] MySQL Verification Team 
Thank you for the bug report feature request.
[30 Sep 2009 11:48] Valeriy Kravchuk 
Duplicate of Bug #6373.