$fld_one ='SHOW COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE SCHEMA = '.$dbone'.'AND TABLE NAME = '.$tbone.'';
SHOW COLUMNS FROM $tbone FROM mydb;
它的查询给出了allcolumn_name
SELECT group_concat(column_name)
FROM information_schema.columns
WHERE table_schema = 'DB_NAME' AND table_name = 'TABLE_NAME'
这应该能满足您的需求。
$sql="select `column_name`
from `information_schema`.`columns`
where `table_schema`=database() and `table_name`='$tbone';";