You can enter single- or multi-statement SQL queries using Data Definition Language (DDL), Data Control Language (DCL), or Data Manipulation Language (DML) statements in the query box.
- DDL statements
- Begin with SQL keywords, such as CREATE, ALTER, DROP, DELETE, MODIFY, HELP, SHOW, SET, REPLACE.
- DCL statements
- Begin with SQL keywords GRANT, REVOKE, GIVE.
- DML statements
- Begin with SQL keywords, such as SELECT, INSERT, UPDATE.
For single-statement queries, enter the query, optionally followed by a semicolon. For multi-statement queries, each statement must end with a semicolon.