Function Overview

Data Admin Service (DAS) is a one-stop platform that allows you to manage cloud databases on a web console. DAS offers database development, O&M, and intelligent diagnosis, making it easy for you to use and maintain cloud databases. DAS provides an easy-to-use console, and you do not need to install clients locally. The console allows you to synchronize and edit data and table structures online, and provides other diverse functions, such as displaying intelligent tips for you to enter SQL statements.

Is installation-free, allowing you to log in to a DB instance, create databases and tables, and execute SQL statements online.

Covers tables, views, stored procedures, events, triggers, and functions.

①Tables: A MySQL data table consists of basic information, field/column information, virtual columns, indexes, and foreign keys, of which, the virtual columns, indexes, and foreign keys are optional. You can manipulate data in a table by performing operations on the table.

②Views: A view is a mapping of one or more tables. Generally, it is only used for queries.

③Events: An event is a time trigger, which can complete a specific operation at a specific time.

④Stored procedures: A stored procedure is a set of SQL statements that are compiled and stored in a database. You can modify corresponding parameters to complete a specific operation.

⑤Triggers: A trigger is an SQL statement designed to be automatically executed on a table in response to an operation (addition, deletion, or modification) on another associated table. Triggers are used to strengthen data integrity and atomicity event rules.

⑥Functions: include system functions and user-defined functions. You can set different functions to reuse a feature.