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