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

最新推荐文章于 2024-09-06 11:27:41 发布

iteye_5904

最新推荐文章于 2024-09-06 11:27:41 发布

阅读量2.5k

点赞数

CC 4.0 BY-SA版权

本文链接：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.

The resulting data from the MySQL CLI looks like this for the example table above: