Setting and Clearing the Secondary Engine Attribute of a Data Table

To set and clear the secondary engine attribute of a data table, you must have the permission to modify the data table. When unloading the secondary engine or managing and maintaining the data table, you may be involved in setting the secondary engine attribute of the data table. This section uses the test table t1 as an example.

Setting the Secondary Engine Attribute of a Data Table

Log in to the MySQL service through the MySQL client.
Set the secondary engine of the data table to kovae. t1 indicates the name of the target table. Change it based on actual requirements.
```
ALTER TABLE t1 SECONDARY_ENGINE = kovae;
```
If the following information is displayed, the operation is successful:
```
Query OK, 0 rows affected (0.01 sec)
Records: 0  Duplicates: 0  Warnings: 0
```

Clearing the Secondary Engine Attribute of a Data Table

Log in to the MySQL service through the MySQL client.
Clear the secondary engine configuration information of the data table. t1 indicates the name of the target table. Change it based on actual requirements.
```
ALTER TABLE t1 SECONDARY_ENGINE = null;
```
If the following information is displayed, the operation is successful:
```
Query OK, 0 rows affected (0.01 sec)
Records: 0  Duplicates: 0  Warnings: 0
```

Parent topic: Feature Usage