[Dbix-class] SQL::Abstract : adding support for two potentially MySQL-specific functions

Jose Luis Martinez jlmartinez-lists-dbix at capside.com
Mon Mar 9 08:45:14 GMT 2009


Rob Kinyon escribió:
> On Sun, Mar 8, 2009 at 07:08, Spiros Denaxas <s.denaxas at gmail.com> wrote:
>> Hello,
>>
>> I recently contacted Matt regarding SQL::Abstract and how to add support for
>> two features which I *think* are MySQL specific:
>>
>> 1) REPLACE (more info: http://dev.mysql.com/doc/refman/6.0/en/replace.html)
>> 2) UPDATE statements on multiple tables (more info:
>> http://dev.mysql.com/doc/refman/6.0/en/update.html)
>>
>> Please correct me if I am wrong in thinking that these are MySQL specific -
>> I have not really looking into other RDBMS's.
> 
> They are certainly non-standard extensions. I'm not sure if they are
> limited only to MySQL. In addition, you will want to have multi-table
> DELETE supported.
> 
And INSERT ... ON DUPLICATE KEY UPDATE ...? (available in MySQL
http://dev.mysql.com/doc/refman/5.0/en/insert.html)

Maybe it's already supported?


Regards,

Jose Luis Martinez
jlmartinez at capside.com




More information about the DBIx-Class mailing list