[TDR Generic Table] [MySQL Protocol Compatibility Interface] Traverse Full Table

1. Interface Description

Traverse all records in a specified table

2. Preparations

Refer to Preparation document, create mysql_table table, and use MySQL Client to connect to TcaplusDB successfully.

3. Limitations

TcaplusDB supports full table traversal (by default, traversal occurs on the slave node), but the traversal operation is not transactional and may impact online app point-to-point performance.Please use it cautiously after evaluation.

4. SQL Examples

1. When traversing all records in mysql_table on the slave node, the SQL statement is as follows:

SELECT * FROM `mysql_table` USE SACN;

1. When traversing all records in mysql_table on the master node, the SQL statement is as follows:

SELECT * FROM `mysql_table` USE MASTER SACN;

1. When traversing the specified number of records in mysql_table on the slave node, the SQL statement is as follows:

SELECT * FROM `mysql_table` USE SCAN LIMIT 100;

1. When traversing the qualified records in mysql_table on the slave node, the SQL statement is as follows:

SELECT * FROM `mysql_table` USE SCAN WHERE v4 LIKE '%boy%';

5. FAQ

For details, see Meaning and Handling of Error Codes.

6. Other Reference Documents

[TDR Generic Table][C++ SDK] Interface Description for Traversing Table Data

[TDR Generic Table] [Java SDK] Interface Description for Scanning Full Table Data

[TDR Generic Table] [Go SDK] Interface Description for Traversing Table Data