Help Center> Data Admin Service> Getting Started> Data Management> Step 4: Managing Data
View PDF

Step 4: Managing Data

Table Management

  1. On the Objects tab page, select Tables. Click Create Table and specify information such as the table name and storage engine.

    Figure 1 Creating a table

  2. Ensure the settings are correct and click Next. Then add table columns.
  3. Click Next and add virtual columns, indexes, and foreign keys.
  4. Click Create. In the SQL Preview dialog box, click Back if there is something wrong, and click Execute to create the table if everything is correct.

    Figure 2 SQL preview

View Management

  1. On the Objects tab page, select Views. Click Create View and specify information such as the view name, algorithm, security, and view definition statement.

    Figure 3 Creating a view

  2. Click Create. In the SQL Preview dialog box, click Back if there is something wrong, and click Execute to create the view if everything is correct.

    Figure 4 SQL preview

Stored Procedure Management

  1. On the Objects tab page, select Stored Procedures. Click Create Stored Procedure and specify the name and description.

    Figure 5 Creating a stored procedure

  2. Ensure the settings are correct and click OK. The Create Stored Procedure page is displayed.
  3. Click Option and configure the information such as SQL security and data access.

    Figure 6 Configuring options

  4. Ensure the settings are correct, and click OK and then Save.
  5. Click Execute to create a stored procedure.

    Figure 7 SQL execution

Event Management

  1. On the Objects tab page, select Events. Click Create Event and specify information such as the event name, status, remarks, and event definition statements.

    Figure 8 Creating an event

  2. Click Create. In the SQL Preview dialog box, click Back if there is something wrong, and click Execute to create the event if everything is correct.

    Figure 9 SQL preview

Trigger Management

  1. On the Objects tab page, select Triggers. Click Create Trigger and specify information such as the trigger name, trigger table, trigger condition, trigger event, and trigger definition statement.

    Figure 10 Creating a trigger

  2. Click Create. In the SQL Preview dialog box, click Back if there is something wrong, and click Execute to create the trigger if everything is correct.

    Figure 11 SQL preview

Function Management

  1. On the Objects tab page, select Functions. Click Create Function and specify information such as the function name and description.

    Figure 12 Creating a function

  2. Ensure the settings are correct and click OK. The SQL preview page is displayed.
  3. Click Option and configure the information such as SQL security and data access.

    Figure 13 Configuring options

  4. Ensure the settings are correct, and click OK and then Save. Then click Execute to create the function. If you want to modify SQL statements, modify them in the SQL window and then click Execute.

    Figure 14 SQL execution

Parent topic: Data Management