SQL syntax overview

This topic describes the SQL syntax and operations in PolarDB-X.

PolarDB-X is highly compatible with the SQL syntax in MySQL. The syntax characteristics of PolarDB-X are not the same as those of MySQL due to the architecture differences between distributed databases and single-instance databases. This chapter also describes the following types of SQL commands in PolarDB-X:

  • DDL: You can define, modify, and delete resources in databases by using this language. For example, you can create and delete tables.

  • DML: You can change the data content that is stored in databases by using this language. For example, you can add, modify, and delete data.

  • Data Query Language (DQL): This language is known as the data retrieval language. You can use this language to retrieve data from tables and specify how to return the data to programs for output.

  • Transaction Control Language (TCL): This language ensures the integrity and consistency of databases. The TCL statements in the same transaction all succeed or fail.

  • Data Access Language (DAL): You can run commands related to O\&M by using this language. You can use these commands to manage and optimize databases.

results matching ""

    No results matching ""