MERGE function/method in MariaDB (SOLVED)

[fraxzi]

Hi All,

I'm new to MariaDB. Is there a similar MERGE (update/insert) in MariaDB Class or similar?

[Marc Vanzegbroeck]

Frances,

Do you mean the update query?
https://dev.mysql.com/doc/refman/8.0/en/update.html

[fraxzi]

Frances,

Do you mean the update query?
https://dev.mysql.com/doc/refman/8.0/en/update.html

Hi Marc,

In ADS there is MERGE where it insert a record if not exist then update it if exists.

[fraxzi]

Hi All,

I think I found it...

https://mariadb.com/kb/en/library/insert-on-duplicate-key-update/

I will try this sooner..

[nageswaragunupudi]

All this is simpler if you use FWH Maria DB

Code: Select all  Expand view

oCn:Insert( <ctable>, <fieldlist>, <aValues>, .T. ) // last param .T.
 

If the last param is .T., this will update in case of duplicate or insert if it is not duplicate.

[fraxzi]

All this is simpler if you use FWH Maria DB

Code: Select all  Expand view

oCn:Insert( <ctable>, <fieldlist>, <aValues>, .T. ) // last param .T.
 

If the last param is .T., this will update in case of duplicate or insert if it is not duplicate.

Hi Mr. Rao,

This is much better!

Thanks,
Frances