PHP查询MYSQL表的主键

$sql = "SELECT * from Person";

$result = mysql_query($sql,$con);

while ($property = mysql_fetch_field($result))

  {

  echo "Field name: " . $property->name . "<br />";

  echo "Table name: " . $property->table . "<br />";

  echo "Default value: " . $property->def . "<br />";

  echo "Max length: " . $property->max_length . "<br />";

  echo "Not NULL: " . $property->not_null . "<br />";

  echo "Primary Key: " . $property->primary_key . "<br />";

  echo "Unique Key: " . $property->unique_key . "<br />";

  echo "Mutliple Key: " . $property->multiple_key . "<br />";

  echo "Numeric Field: " . $property->numeric . "<br />";

  echo "BLOB: " . $property->blob . "<br />";

  echo "Field Type: " . $property->type . "<br />";

  echo "Unsigned: " . $property->unsigned . "<br />";

  echo "Zero-filled: " . $property->zerofill . "<br /><br />";

  }

关键字段：
echo "Primary Key: " . $property->primary_key . "<br />";

巴特西

PHP查询MYSQL表的主键

最新文章

热门文章