MySQL: 获取表结构 Get a MySQL table structure with DESCRIBE

最新推荐文章于 2021-10-29 15:16:43 发布

iteye_5904

最新推荐文章于 2021-10-29 15:16:43 发布

阅读量2.5k

点赞数

本文链接：https://blog.youkuaiyun.com/iteye_5904/article/details/82649940

版权

本文介绍了如何使用MySQL的DESCRIBE命令和PHP来获取表结构，并提到了通过查询INFORMATION_SCHEMA获取更详细信息的方法。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Example table

The example table used in this post was created with the following SQL:

CREATE TABLE `products` (
`product_id` int(10) unsigned NOT NULL auto_increment,
`url` varchar(100) NOT NULL,
`name` varchar(50) NOT NULL,
`description` varchar(255) NOT NULL,
`price` decimal(10,2) NOT NULL,
`visible` tinyint(1) unsigned NOT NULL default '1',
PRIMARY KEY (`product_id`),
UNIQUE KEY `url` (`url`),
KEY `visible` (`visible`)
)

Using DESCRIBE

The SQL query to get the table structure is:

DESCRIBE products;

You can run this from the MySQL CLI; phpMyAdmin; or using a programming language like PHP and then using the functions to retrieve each row from the query.