PHP获取mysql表属性_PHP获取mysql数据表的字段名称及详细属性

SHOW DATABASES //列出 MySQL Server 数据库。

SHOW TABLES [FROM db_name] //列出数据库数据表。

SHOW CREATE TABLES tbl_name //导出数据表结构。

SHOW TABLE STATUS [FROM db_name] //列出数据表及表状态信息。

SHOW COLUMNS FROM tbl_name [FROM db_name] //列出资料表字段

SHOW FIELDS FROM tbl_name [FROM db_name]&＃xff0c;DESCRIBE tbl_name [col_name]。

SHOW FULL COLUMNS FROM tbl_name [FROM db_name]//列出字段及详情

SHOW FULL FIELDS FROM tbl_name [FROM db_name] //列出字段完整属性

SHOW INDEX FROM tbl_name [FROM db_name] //列出表索引。

SHOW STATUS //列出 DB Server 状态。

SHOW VARIABLES //列出 MySQL 系统环境变量。

SHOW PROCESSLIST //列出执行命令。

SHOW GRANTS FOR user //列出某用户权限

DESC TABLE //获取表详细信息

1.

mysql_connect("localhost","root","");

mysql_select_db("test");

$query&＃61; "desc student";

$result&＃61; mysql_query($query);

while($row&＃61;mysql_fetch_assoc($result)){

print_r($row);

}

?>

2.

mysql_connect("localhost","root","");

mysql_select_db("test");

$query&＃61; "SHOW FULL COLUMNS FROM student";

$result&＃61; mysql_query($query);

while($row&＃61;mysql_fetch_assoc($result)){

print_r($row);

}

?>

3.

mysql_connect("localhost","root","");

mysql_select_db("test");

$query&＃61; "SELECT * FROM student LIMIT 1";

$result&＃61; mysql_query($query);

$fields&＃61; mysql_num_fields($result);

for($count&＃61;0;$count

{

$field&＃61; mysql_fetch_field($result,$count);

print_r($field);

}

?>