how to find primary key

[mustafacelik]

Is there anyone who knows something about finding the primary key (column) of a mysql table.

By mysql_field_name() function I can find the column names of a table but which one of them is primary key?

Note: This is my first message 🙂

[jernhenrik]

SHOW KEYS
SHOW FIELDS
http://www.mysql.com/doc/en/SHOW_DATABASE_INFO.html

hth