mysql desc

The MySQL desc command is used to view the table structure, which is the shorthand form for the describe command. MySQL desc command syntax: DESC TableName What information does the command display on the table? The specific include:

The tbl_direct_pos_201506 table has 1.9 million data. Ddl:CREATE TABLE ' tbl_direct_pos_201506 ' (' Acq_ins_code ' char () not NULL DEFAULT ' COMMENT ' agency code ', ' Trace_num ' char (6) N OT null default ' COMMENT ' tracking number ', '

tbl_direct_pos_201506 table has 1.9 million data, DDL:CREATE TABLE ' tbl_direct_pos_201506 ' (' Acq_ins_code ' char () not NULL DEFAULT ' COMMENT ' agency code ', ' Trace_num ' char (6) N OT null default ' COMMENT ' tracking number ', '

Source: http://zhumeng8337797.blog.163.com/blog/static/100768914201179112318218/ 1. DESC tablename;For example, mysql> DESC jos_modules;+ ------------------ + --------------------- + ------ + ----- + --------------------- + ---------------- +| FIELD

Note: Use BTREE to comindex ASC/DESC of each field to optimize order by query efficiency. btreeascThe tbl_direct_pos_201506 table has 1.9 million data, DDL: Create table 'tbl _ direct_pos_201506 '('acq _ ins_code' char (13) not null default

When using mysql, when I want to use desc to view the table structure, the following error message is displayed: ERROR 1 (HY000): Can't create/write to file '/tmp/#sql_1737_0.MYI' (Errcode: 13) I have never met anyone. I searched the internet. The

Note: Use the BTREE compound to index the ASC/DESC of each field to optimize the orderby query efficiency.The tbl_direct_pos_201506 table has 1.9 million data, DDL: Create table 'tbl _ direct_pos_201506 '('acq _ ins_code' char (13) not null default '

after the database design is complete, it is often necessary to keep a desc description of all tables in the database in a wiki or other document, in particular the meaning and purpose of each field. It is not advisable to manually generate the

1 How to execute a SQL script file, this script file writes a series of sets of SQL statements, such as Sql.sql placed under D:\MyEclipse 8.6\workspaces\oasystem\webroot\sql.sql"CD D:\MyEclipse 8.6\workspaces\oasystem\webroot\>>sqlplus>>@ Sql.sql;2

Often forget MySQL in ascending and descending with what characters, now make a note: ascending asc, descending desc, for example, the following is a time descending call column of the article, also is the column of the latest