Help Center/ GaussDB/ M-Compatibility Developer Guide(Distributed)/ Application Development Guide/ Database Access Route
Updated on 2025-10-23 GMT+08:00
View PDF
Share

Database Access Route

For details about how to design databases and schemas, see the relevant content in "MySQL Compatibility Description > Overview of MySQL Compatibility > Overview of M-compatible Mode" in Compatibility Description.

  1. Create the database and user by referring to Creating an M-compatible Database and User.
  2. By default, schemas with the same name as omm_test and other default schemas are generated in the m_db database. These schemas are the workspace. You can use any of the following methods to access a data table:

    1. Specify a database and schema to use the table name for access.
    2. Specify a database and do not specify a schema. The system routes the request to the schema with the same name created by the connected user by default and uses schema.table to access the schema.
    3. Specify a database and do not specify a schema. SQL statements or functions are used to switch the schema and directly use the table name for access.