MYSQL 如何获取表主键

解决方案 »

  1.   

    mysql> desc extensions;
    +-------------+--------------+------+-----+---------+-------+
    | Field       | Type         | Null | Key | Default | Extra |
    +-------------+--------------+------+-----+---------+-------+
    | context     | varchar(45)  |      | PRI | default |       |
    | extension   | varchar(45)  |      | PRI |         |       |
    | priority    | varchar(5)   |      | PRI | 1       |       |
    | application | varchar(45)  |      |     |         |       |
    | args        | varchar(255) | YES  |     | NULL    |       |
    | descr       | text         | YES  |     | NULL    |       |
    | flags       | int(1)       |      |     | 0       |       |
    +-------------+--------------+------+-----+---------+-------+KEY这一列标出了主键。 PRI = primary key
      

  2.   

    <?php 
    $mysqli = new mysqli("localhost","user","password","database"); $sql = "describe table"; $re=$mysqli->query($sql); while( $row=$re->fetch_array()){ if($row['Key']=='PRI'){ 
    ECHO $row['Field']."是这个表的主键。"; 
    break; 


    ?> 数组里[key]=>PRI 的 就是主键 
    [Extra] => auto_increment 是自增字段