desc

最近更新时间:2022-05-13 10:15:47

我的收藏

简介

查看表的定义信息。嵌套字段只能看到其属性为嵌套类型,但是无法查看嵌套结构体的定义。

语法

desc [table]/[table.field] [using tdr];

参数

参数
Protobuf
TDR
table
表格的名字
表格的名字
table.field
不支持
显示嵌套字段的结构,必须配合 using tdr 使用
using tdr
不支持
从 tdr 文件中读取表结构,该操作必须在启动 client 时提供 tdr 文件

错误

请参考 错误码列表

示例

tcaplus> desc table_list;

Table Structure From: Tcaplus System
TableName: table_list
TableType: LIST, IdlType: TDRXML
SvrTdrCurrentVersion: 5
+---------------------+--------------------+--------+-----+------+-------+------------+-----+---------------------+--------------+
|Field |Type |Key |Index|Size |Version|DefaultValue|Count|Select |Desc |
+---------------------+--------------------+--------+-----+------+-------+------------+-----+---------------------+--------------+
|uin |unsigned long long |PRI,SPLT|- |8 |1 |- |1 |- |QQ |
+---------------------+--------------------+--------+-----+------+-------+------------+-----+---------------------+--------------+
|name |string |PRI |- |640 |1 |- |1 |- |Name |
+---------------------+--------------------+--------+-----+------+-------+------------+-----+---------------------+--------------+
|key1 |unsigned char |PRI |- |1 |1 |- |1 |- |key4 |
+---------------------+--------------------+--------+-----+------+-------+------------+-----+---------------------+--------------+
|level |int |- |- |4 |1 |1 |1 |- |- |
+---------------------+--------------------+--------+-----+------+-------+------------+-----+---------------------+--------------+
|count |unsigned char |- |- |1 |1 |0 |1 |- |- |
+---------------------+--------------------+--------+-----+------+-------+------------+-----+---------------------+--------------+
|array_count |unsigned int |- |- |4 |1 |1 |1 |- |- |
+---------------------+--------------------+--------+-----+------+-------+------------+-----+---------------------+--------------+
|items |unsigned long long[]|- |- |8 |1 |- |10 |- |- |
+---------------------+--------------------+--------+-----+------+-------+------------+-----+---------------------+--------------+
|c_int8 |char |- |- |1 |1 |-1 |1 |- |- |
+---------------------+--------------------+--------+-----+------+-------+------------+-----+---------------------+--------------+
|c_uint8 |unsigned char |- |- |1 |1 |2 |1 |- |- |
+---------------------+--------------------+--------+-----+------+-------+------------+-----+---------------------+--------------+
|c_int16 |short |- |- |2 |1 |-3 |1 |- |- |
+---------------------+--------------------+--------+-----+------+-------+------------+-----+---------------------+--------------+
|c_uint16 |unsigned short |- |- |2 |1 |4 |1 |- |- |
+---------------------+--------------------+--------+-----+------+-------+------------+-----+---------------------+--------------+
|c_int32 |int |- |- |4 |1 |-5 |1 |- |- |
+---------------------+--------------------+--------+-----+------+-------+------------+-----+---------------------+--------------+
|c_uint32 |unsigned int |- |- |4 |1 |6 |1 |- |- |
+---------------------+--------------------+--------+-----+------+-------+------------+-----+---------------------+--------------+
|c_int64 |long long |- |- |8 |1 |-7 |1 |- |- |
+---------------------+--------------------+--------+-----+------+-------+------------+-----+---------------------+--------------+
|c_uint64 |unsigned long long |- |- |8 |1 |- |1 |- |- |
+---------------------+--------------------+--------+-----+------+-------+------------+-----+---------------------+--------------+
|c_float |float |- |- |4 |2 |1.234568 |1 |- |- |
+---------------------+--------------------+--------+-----+------+-------+------------+-----+---------------------+--------------+
|c_double |double |- |- |8 |3 |9.876543 |1 |- |- |
+---------------------+--------------------+--------+-----+------+-------+------------+-----+---------------------+--------------+
|c_string |string |- |- |200 |3 |- |1 |- |- |
+---------------------+--------------------+--------+-----+------+-------+------------+-----+---------------------+--------------+
|c_string_128K |string |- |- |131072|1 |123456789 |1 |- |- |
+---------------------+--------------------+--------+-----+------+-------+------------+-----+---------------------+--------------+
|c_string_256K |string |- |- |262144|1 |123456789 |1 |- |- |
+---------------------+--------------------+--------+-----+------+-------+------------+-----+---------------------+--------------+
|c_binary |char[] |- |- |1 |1 |- |10 |- |- |
+---------------------+--------------------+--------+-----+------+-------+------------+-----+---------------------+--------------+
|binary |char |- |- |1 |5 |- |1 |- |- |
+---------------------+--------------------+--------+-----+------+-------+------------+-----+---------------------+--------------+
|selector |short |- |- |2 |1 |- |1 |- |- |
+---------------------+--------------------+--------+-----+------+-------+------------+-----+---------------------+--------------+
|single_struct |struct_type |- |- |119 |1 |- |1 |- |- |
+---------------------+--------------------+--------+-----+------+-------+------------+-----+---------------------+--------------+
|simple_struct |simple_struct |- |- |30 |4 |- |1 |- |- |
+---------------------+--------------------+--------+-----+------+-------+------------+-----+---------------------+--------------+
|single_union_selector|char |- |- |1 |1 |0 |1 |- |- |
+---------------------+--------------------+--------+-----+------+-------+------------+-----+---------------------+--------------+
|single_union |union_type |- |- |64 |1 |- |1 |single_union_selector|- |
+---------------------+--------------------+--------+-----+------+-------+------------+-----+---------------------+--------------+
|array |TableInfo[] |- |- |125 |1 |- |3 |- |three lyaer struct|
+---------------------+--------------------+--------+-----+------+-------+------------+-----+---------------------+--------------+
|c_union |union_type |- |- |64 |1 |- |1 |selector |- |
+---------------------+--------------------+--------+-----+------+-------+------------+-----+---------------------+--------------+
|union_array |union_type[] |- |- |64 |1 |- |3 |selector |- |
+---------------------+--------------------+--------+-----+------+-------+------------+-----+---------------------+--------------+
|c_struct |struct_type |- |- |119 |1 |- |1 |- |- |
+---------------------+--------------------+--------+-----+------+-------+------------+-----+---------------------+--------------+
|struct_array |struct_type[] |- |- |119 |1 |- |3 |- |- |
+---------------------+--------------------+--------+-----+------+-------+------------+-----+---------------------+--------------+

32 rows in set (36252 us)

tcaplus> desc table_list.single_struct using tdr;

Table Structure From: Local tdr file(/mnt/e/tdr/2.3.table_list.tdr)
table_list.single_struct
|---single_struct(struct)
| |---x(int)
| |---y(int)
| |---score(double)
| |---rank(uchar)
| |---title(string)
| |---level2_struct(struct)
| | |---uin(int)
| | |---name(string)