Want to Know about this Option

[caradoc]

I know about INSERT option in MySQL. But I want to know the usage of the option INSERT DELAYED in MySQL? Is this same as INSERT option or is it different?

[sammy]

INSERT DELAYED is used when a user want to do an insert but don't want to wait for perhaps lengthy selects that are being run by other clients to complete. This is a added feature of the option INSERT