Enumeration
SQLUpsertSyntax
The supported syntax variants which a SQL dialect can use to to specify conflict resolution clauses.
enum SQLUpsertSyntaxTopics
Enumeration Cases
SQLUpsertSyntax.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.SQLUpsertSyntax.standardIndicates support for the SQL-standardON CONFLICT ...syntax, including index and update predicates, theexcluded.pseudo-table name, and theDO NOTHINGaction for “ignore conflicts”.SQLUpsertSyntax.unsupportedIndicates lack of any support for conflict resolution.
Relationships
Conforms To
Swift.CaseIterableSwift.EquatableSwift.HashableSwift.SendableSwift.SendableMetatype
See Also
Drivers
SQLDialectAn abstract definition of a specific dialect of SQL.SQLDatabaseReportedVersionProvides a protocol for reporting and comparing database version numbers.SQLAlterTableSyntaxEncapsulates a dialect’s support forALTER TABLEsyntax.SQLTriggerSyntaxEncapsulates a dialect’s support forCREATE TRIGGERandDROP TRIGGERsyntax.SQLUnionFeaturesA set of feature support flags forUNIONqueries.SQLEnumSyntaxPossible values for a dialect’s strongly-typed enumeration support.