mysql 获取列名sql语句

select
GROUP_CONCAT(CONCAT('i.',COLUMN_NAME,''))
from
(
select COLUMN_NAME from information_schema.COLUMNS where table_name = 'inventorycheck' and table_schema = 'hystorage'
)t

以上就是mysql 获取列名sql语句的详细内容，更多关于mysql 获取列名sql语句的资料请关注九品源码其它相关文章！