tencent cloud

TencentDB for TcaplusDB

文档TencentDB for TcaplusDBKlien TcaplusDBPerintah Alat Kliendeskripsi

deskripsi

下载
聚焦模式
字号
最后更新时间： 2024-12-04 10:32:14

Ikhtisar

Perintah ini digunakan untuk melihat informasi definisi tabel. Untuk bidang nested, Anda hanya dapat melihat bahwa atributnya adalah jenis nested, tetapi Anda tidak dapat melihat definisi struktur nested.

Sintaksis

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

Parameter

Parameter
Protobuf
TDR
tabel
Nama tabel
Nama tabel
table.field
Tidak didukung
Untuk menampilkan struktur bidang nested, using tdr perlu digunakan bersama dengan parameter ini.
menggunakan tdr
Tidak didukung
Parameter ini digunakan untuk menanyakan struktur tabel dari file TDR yang harus disediakan saat klien diluncurkan.

Kesalahan

Untuk informasi selengkapnya, silakan lihat Kode Kesalahan.

Sampel

tcaplus> desc table_list;

Struktur Tabel Dari: Sistem Tcaplus
TableName: table_list
TableType: LIST, IdlType: TDRXML
SvrTdrCurrentVersion: 5
+---------------------+--------------------+--------+-----+------+-------+------------+-----+---------------------+--------------+
|Bidang                |Jenis                |Kunci     |Indeks|Ukuran  |Versi|DefaultNilai|Hitung|Pilih               |Deskripsi          |
+---------------------+--------------------+--------+-----+------+-------+------------+-----+---------------------+--------------+
|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 baris dalam kumpulan (36252 us)

tcaplus> desc table_list.single_struct menggunakan tdr;

Struktur Tabel Dari: File tdr lokal(/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)
上一篇: tampilkan下一篇: hitung

帮助和支持

本页内容是否解决了您的问题？

填写满意度调查问卷，共创更好文档体验。

文档反馈

搜索
    请输入关键词搜索文档