如何获取MySQL中所有表的所有列名称？

select * from information_schema.columns
where table_schema = \'your_db\'
order by table_name,ordinal_position

select * 
  from information_schema.columns 
 where table_schema = \'your_DB_name\' 
   and table_name = \'Your_tablename\'

SELECT * FROM information_schema.columns
WHERE table_schema = DATABASE()
ORDER BY table_name, ordinal_position

Show columns from tablename

SELECT table_name,GROUP_CONCAT(column_name ORDER BY ordinal_position)
FROM information_schema.columns
WHERE table_schema = DATABASE()
GROUP BY table_name
ORDER BY table_name

<?php
        $table = \'orders\';
        $query = \"SHOW COLUMNS FROM $table\";
        if($output = mysql_query($query)):
            $columns = array();
            while($result = mysql_fetch_assoc($output)):
                $columns[] = $result[\'Field\'];
            endwhile;
        endif;
        echo \'<pre>\';
        print_r($columns);
        echo \'</pre>\';
?>

DESCRIBE column_name;

$a = mysqli_query($conn,\"select * from information_schema.columns
where table_schema = \'your_db\'
order by table_name,ordinal_position\");
$b = mysqli_fetch_all($a,MYSQLI_ASSOC);
$d = array();
foreach($b as $c){
    if(!is_array($d[$c[\'TABLE_NAME\']])){
        $d[$c[\'TABLE_NAME\']] = array();
    }
    $d[$c[\'TABLE_NAME\']][] = $c[\'COLUMN_NAME\'];
}
echo \"<pre>\",print_r($d),\"</pre>\";

select * from information_schema.columns
where table_schema = \'your_db\'
order by table_name,ordinal_position

select COLUMN_NAME from information_schema.columns
where table_schema = \'your_db\'
order by table_name,ordinal_position