show table structure in mysql

MySQL常用指令，java，php程序员，数据库工程师必备。程序员小冰常用资料整理MySQL common commands (for reference)The most common display commands are:1. Display the list of databases.show databases;2. Display the data table in the library:Use MySQL;Show tables;3, display the

In order to better optimize MySQL in high concurrency, it is necessary to understand the locking table mechanism when MySQL query is updated.I. OverviewMySQL has three levels of Lock: page level, table level, row level.MyISAM and MemoryStorageThe

Three methods for copying table data and table structure in mysql When will we use a copy table? For example, if I operate on a table but are afraid of accidental deletion of data, create a table with the same structure in the same database and

Mysql 3-view table structure, modify and delete data tables bitsCN. comMysql 3-view table structure, modify and delete data tables view table structure You can use DESCRIBE or show create table statements to view the TABLE structure. 1. view the

Back up the MySQL data table structure [Root@mysql ~]#/usr/local/mysql/bin/mysqldump-uroot-p ' admin '-D Mysql servers>/backup/mysql-structure-tables-$ ( Date +%f). sql[Root@mysql ~]# egrep-v

1. View Data Table Structure 1) view the basic table structure statement DESCRIBE syntax: DESCRIBE table name; example: mysqlDESCRIBEproduct; + ---------------- + ------------ + ------ + ----- + --------- + ---------------- + | Field 1. view the

Original source: MySQL 5.5 Reference ManualPart of the translation: "mysql_5.1 Chinese reference Manual"Reprint please specify the original link http://www.cnblogs.com/lenagt/archive/2012/06/06/2538201.html Thank you.---------------------------------

Basic MySQL Data Table operation 2: Table Structure View, modification, and table operation 1. view the data table structure 1) view the basic table structure statement DESCRIBE Syntax:DESCRIBETable Name; Example: mysql> DESCRIBE product;+-----------

MySQL creates a table and creates a . frm file to save the table and column definitions. The index is stored in one . MYI (Myindex) and the data is stored in the . MYD (MYData) file extension. First, using Show/describe statement to display the data

MYSQL uses. frm to restore the data table structure implementation method bitsCN.com. we all know that when we create a data table (innodb or myisam), a corresponding file (such as MYD, MYI, frm) will be generated) Here, we will discuss how to use