mysql数据库输出字段信息

来源：互联网发布：渭南加工中心编程招聘编辑：程序博客网时间：2024/05/21 10:17

<?phpmysql_connect("127.0.0.1:3336","root","myoa888");mysql_select_db("TD_OA");$ip=$_SERVER['REMOTE_ADDR'];$sql="SELECT column_name AS `列名`, data_type   AS `数据类型`, character_maximum_length  AS `字符长度`, numeric_precision AS `数字长度`, numeric_scale AS `小数位数`, is_nullable AS `是否允许非空`, column_default  AS  `默认值`, column_comment  AS  `备注` FROM Information_schema.columns WHERE TABLE_SCHEMA='TD_OA' and  table_Name='sys_function' order by ORDINAL_POSITION asc";$q=mysql_query($sql);echo "<table border=1>";echo "<tr style='background-color:#ccc'>";echo "<td>列名</td>";echo "<td>字段描述</td>";echo "<td>数据类型</td>";echo "<td>字符长度</td>";echo "<td>数字长度</td>";echo "<td>小数位数</td>";echo "<td>是否允许非空</td>";echo "<td>默认值</td>";echo "</tr>";$i=2;while($r=mysql_fetch_array($q)){if((abs($i)+2)%2==1){echo "<tr style='background-color:#eee'>";}else{echo "<tr>";}echo "<td>".$r[列名]."</td>";echo "<td>".$r[备注]."</td>";echo "<td>".$r[数据类型]."</td>";echo "<td>".$r[字符长度]."</td>";echo "<td>".$r[数字长度]."</td>";echo "<td>".$r[小数位数]."</td>";echo "<td>".$r[是否允许非空]."</td>";echo "<td>".$r[默认值]."</td>";echo "</tr>";$i++;}echo "</table>";?>

0 0