CodePudding
Home
front end
Back-end
Net
Software design
Enterprise
Blockchain
Mobile
Software engineering
database
OS
other
Home
>
database
> Mysql have similar oracle merge into function, now see update functions are based on the primary key
Mysql have similar oracle merge into function, now see update functions are based on the primary key
Time:10-11
Merge into can make judgment according to the field is not the primary key column exists, then update or insert
CodePudding user response:
Need to write their own function
Page link:
https//www.codepudding.com/database/62302.html
Prev:
Excuse me, triggers and stored procedures can be optimized query speed?
Next:
Need big answer database
Tags:
MySQL
Related
Excuse me, triggers and stored procedures can be optimized q
About the upsert need to insert and update statistics counti
Small white: about how to implement the query statistics
ES psotgresql synchronous data, multicorn create problems
Optimizer trace not generate tracking information?
postgis
The progress of the load data infile
AttributeError: 'LXML. Etree. _ElementUnicodeResult' object
The pseudo column of the teradata database
PostgreSQL performance is far lower than the used????
Links:
CodePudding