如何从 MySQL 中提取列名称和类型?
mysqlmysqli database更新于 2024/10/9 16:44:17
要提取列名称和类型，请使用 INFORMATION_SCHEMA.COLUMNS −
select concat(column_name,'=',data_type) as anyAliasName from information_schema.columns where table_schema= yourDatabaseName and table_name= yourTableName;
首先我们创建一个表 −
mysql> create table DemoTable1812
(
Id int,
FirstName varchar(20),
Age int,
isMarried boolean,
status ENUM('ACTIVE','INACTIVE')
);
Query OK, 0 rows affected (0.00 sec)
这是从 MySQL 中提取列名和类型的查询:
mysql> select concat(column_name,'=',data_type) as COLUMNNAMEANDTYPE from information_schema.columns where table_schema= 'web' and table_name= 'DemoTable1812';
这将产生以下输出 −
+-------------------+ | COLUMNNAMEANDTYPE | +-------------------+ | Id=int | | FirstName=varchar | | Age=int | | isMarried=tinyint | | status=enum | +-------------------+ 5 rows in set (0.00 sec)
相关文章
有用资源
mysql 参考教程 - 该教程包含有关 mysql 的更多信息:https://www.cainiaomax.com/mysql/
