FiveTech Support Forums

FiveWin / Harbour / xBase community
Board indexActive topicsAll discussionsLogin (GitHub)
Board index FiveWin for Harbour/xHarbour MERGE function/method in MariaDB (SOLVED)
fraxzi
Posts: 811
Joined: Tue May 06, 2008 04:28 AM

MERGE function/method in MariaDB (SOLVED)

Posted: Wed May 16, 2018 05:19 AM

Hi All,

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

Kind Regards,

Frances



Fivewin for xHarbour v18.07

xHarbour v1.2.3.x

BCC 7.3 + PellesC8 ( Resource Compiler only)

ADS 10.1 / MariaDB

Crystal Reports 8.5/9.23 DE

xMate v1.15
Marc Vanzegbroeck
Posts: 1195
Joined: Mon Oct 17, 2005 05:41 AM

Re: MERGE function/method in MariaDB

Posted: Wed May 16, 2018 06:02 AM
Frances,

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

Marc



FWH32+xHarbour | FWH64+Harbour | BCC | DBF | ADO+MySQL | ADO+MariaDB | ADO+SQLite
fraxzi
Posts: 811
Joined: Tue May 06, 2008 04:28 AM

Re: MERGE function/method in MariaDB

Posted: Wed May 16, 2018 06:08 AM
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.
Kind Regards,

Frances



Fivewin for xHarbour v18.07

xHarbour v1.2.3.x

BCC 7.3 + PellesC8 ( Resource Compiler only)

ADS 10.1 / MariaDB

Crystal Reports 8.5/9.23 DE

xMate v1.15
fraxzi
Posts: 811
Joined: Tue May 06, 2008 04:28 AM

Re: MERGE function/method in MariaDB

Posted: Wed May 16, 2018 06:31 AM
Hi All,

I think I found it... :-)

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

I will try this sooner.. :-)
Kind Regards,

Frances



Fivewin for xHarbour v18.07

xHarbour v1.2.3.x

BCC 7.3 + PellesC8 ( Resource Compiler only)

ADS 10.1 / MariaDB

Crystal Reports 8.5/9.23 DE

xMate v1.15
nageswaragunupudi
Posts: 10733
Joined: Sun Nov 19, 2006 05:22 AM

Re: MERGE function/method in MariaDB (SOLVED)

Posted: Wed May 16, 2018 07:35 AM
All this is simpler if you use FWH Maria DB

Code (fw): Select all Collapse
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.
Regards



G. N. Rao.

Hyderabad, India
fraxzi
Posts: 811
Joined: Tue May 06, 2008 04:28 AM

Re: MERGE function/method in MariaDB (SOLVED)

Posted: Wed May 16, 2018 08:20 AM
nageswaragunupudi wrote:All this is simpler if you use FWH Maria DB

Code (fw): Select all Collapse
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
Kind Regards,

Frances



Fivewin for xHarbour v18.07

xHarbour v1.2.3.x

BCC 7.3 + PellesC8 ( Resource Compiler only)

ADS 10.1 / MariaDB

Crystal Reports 8.5/9.23 DE

xMate v1.15

Continue the discussion

Static archive · New replies & topics via GitHub Discussions