List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:August 31 1999 9:00pm
Subject:Enhancement Req: REPLACE vs. INSERT
View as plain text  
>>>>> "Ornoth" == Ornoth Liscomb <OLiscomb@stripped> writes:

Ornoth> MySQL supports multi-row insertions with INSERT ... VALUES
Ornoth> (...),(...),(...). But it is my understanding that it does not presently
Ornoth> support REPLACE ... VALUES (...),(...),(...). That'd be a really nice
Ornoth> enhancement, IMO.

REPLACE works with many rows.

Ornoth> Also, are there any limitations on the number of rows or the length of this
Ornoth> type of multi-row INSERT statement? And if not, does Perl DBI impose any
Ornoth> such limitations?

max_packet_length (in the mysqld server) is the only restriction...

Regards,
Monty
Thread
Enhancement Req: REPLACE vs. INSERTOrnoth Liscomb31 Aug
  • Re: Enhancement Req: REPLACE vs. INSERTThimble Smith1 Sep
  • Enhancement Req: REPLACE vs. INSERTMichael Widenius1 Sep