tencent cloud

TencentDB for TcaplusDB

Catatan Rilis
Deskripsi Produk
Ikhtisar Produk
Manfaat
Kasus Penggunaan
Arsitektur
Ikhtisar Wilayah
Panduan Pembelian
Harga Produk
Pembayaran Jatuh Tempo
Memulai
Konsep Dasar
Membuat Kluster
Membuat Grup Tabel
Membuat Tabel
Akses TcaplusDB
Panduan Operasi
Mengelola Kluster dan Grup Tabel
Mengelola Tabel
Pemantauan dan Pengaturan Alarm
Manajemen Akses
Tag
Daftar Tugas
Klien TcaplusDB
Mengakses dengan Alat Klien
Perintah Alat Klien
Tutorial Praktis
Praktik Terbaik untuk Desain Struktur Tabel
Praktik Terbaik untuk Interaksi Database
Pertanyaan Umum
Fitur Database
Penggunaan Database
Prinsip Database
Service Agreement
Service Level Agreement
Terms of Service
Glosarium
Hubungi Kami
DokumentasiTencentDB for TcaplusDBKlien TcaplusDBPerintah Alat Kliendeskripsi

deskripsi

PDF
Mode fokus
Ukuran font
Terakhir diperbarui: 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)
Topik sebelumnya: tampilkanTopik selanjutnya: hitung

Bantuan dan Dukungan

Apakah halaman ini membantu?

masukan