INSERT LIMITS

[jaymc]

Is there any point putting a LIMIT on an insert

 

Obviously the data is only going to be inserted once, but for performance is it better adding LIMIT 1 at the end?

 

Thanks!

[Tyche]

Strictly speaking the INSERT command does not recognise LIMIT and a

 

INSERT ... SET col=... LIMIT 1 will fail as will INSERT  ... VALUES (...),(...) LIMIT 2 command

 

You can use LIMIT on an INSERT .... SELECT ... Command but there the LIMIT is an optional part of the SELECT command component, its use here should improve performance in many cases