FiveTech Software tech support forums

Hi All,

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

Frances,

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

Marc Vanzegbroeck wrote: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.

Hi All,

I think I found it...

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

I will try this sooner..

All this is simpler if you use FWH Maria DB


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

nageswaragunupudi wrote:All this is simpler if you use FWH Maria DB

Code: Select all | Expand

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