Enumeration
SQLUpsertSyntax
The supported syntax variants which a SQL dialect can use to to specify conflict resolution clauses.
enum SQLUpsertSyntax
Topics
Enumeration Cases
case mysqlLikeIndicates support for the nonstandardON DUPLICATE KEY UPDATE ...syntax, theVALUES()function, andINSERT IGNOREfor “ignore conflicts”. This syntax does not support conflict targets or update predicates.case standardIndicates support for the SQL-standardON CONFLICT ...syntax, including index and update predicates, theexcluded.pseudo-table name, and theDO NOTHINGaction for “ignore conflicts”.case unsupportedIndicates lack of any support for conflict resolution.
Relationships
Conforms To
Swift.CaseIterableSwift.EquatableSwift.HashableSwift.SendableSwift.SendableMetatype
See Also
Drivers
protocol SQLDialectAn abstract definition of a specific dialect of SQL.protocol SQLDatabaseReportedVersionProvides a protocol for reporting and comparing database version numbers.struct SQLAlterTableSyntaxEncapsulates a dialect’s support forALTER TABLEsyntax.struct SQLTriggerSyntaxEncapsulates a dialect’s support forCREATE TRIGGERandDROP TRIGGERsyntax.struct SQLUnionFeaturesA set of feature support flags forUNIONqueries.enum SQLEnumSyntaxPossible values for a dialect’s strongly-typed enumeration support.