TcaplusDB Client - Count Command
For TcaplusDB Client Instructions, see Document.
1. Function Descriptions
Query the total number of records in a data table. Note: The table being relocated does not support count. Please wait for the table to be relocated and count after it is completed
2. Initial Version
3.20.0
3. Command Syntax
count [* | table];
Parameter description:
| Parameter | Description |
|---|---|
| * | Indicates to query the number of records of all tables in the currently connected TcaplusDB |
| table | Indicates to query the total number of records in a specified table |
4. Command Example
See Table Definition Example for table definition.
tcaplus> count table_list;
--------------------------------------------------------------------------------
| TableName Count |
--------------------------------------------------------------------------------
| table_list 16 |
--------------------------------------------------------------------------------
tcaplus> count *;
--------------------------------------------------------------------------------
| TableName Count |
--------------------------------------------------------------------------------
| test_table 33 |
| PLAYERONLINECNT 1092092 |
| table_list 37 |
| table_list1 1 |
| lstFriendMail 3 |
| tb_sgame_onlinecnt 0 |
| test_expan_table 2 |
| table_generic_simple 0 |
| table_list2 6 |
| TB_USER_OFFLINE_RESULT1 3 |
--------------------------------------------------------------------------------
5. Common Errors
Refer to Common Errors.