Supported SQL statements

Devart ODBC Driver for MySQL supports a wide range of SQL statements required for most database operations. For the full syntax and a complete list of SQL statements, see the MySQL documentation: Data Definition Statements, Data Manipulation Statements, Account Management Statements, and Transactional and Locking Statements.

Data Definition Language (DDL) statements

DDL statements define and manage schema objects. They typically require exclusive access to the specified object.

The supported DDL statements include:

• ALTER (all statements beginning with ALTER)
• CREATE (all statements beginning with CREATE)
• DROP (all statements beginning with DROP)
• RENAME
• TRUNCATE

Data Manipulation Language (DML) statements

DML statements access and modify data in existing schema objects.

The supported DML statements include:

• CALL
• DELETE
• DO
• HANDLER
• INSERT
• LOAD DATA [LOCAL] INFILE
• LOAD XML
• LOCK TABLE
• REPLACE
• SELECT
• TRUNCATE TABLE
• UPDATE
• WITH (CTE)

Account Management statements

Account management statements are intended to create, change, delete, and control database user accounts and roles.

The supported account management statements include:

• ALTER USER
• CREATE ROLE
• CREATE USER
• DROP ROLE
• DROP USER
• GRANT
• RENAME USER
• REVOKE
• SET DEFAULT ROLE
• SET PASSWORD
• SET ROLE

Transaction Control statements

Transaction control statements manage changes made by DML operations.

The supported transaction control statements include:

• COMMIT
• ROLLBACK
• SAVEPOINT
• ROLLBACK TO SAVEPOINT
• RELEASE SAVEPOINT
• SET TRANSACTION
• SET CONSTRAINT

Lock Control statements

Lock Control statements give the user deliberate control over how the database handles simultaneous access to data and system metadata.

The supported lock control statements include:

• LOCK TABLES
• UNLOCK TABLES
• LOCK INSTANCE FOR BACKUP
• UNLOCK INSTANCE