How to get primary key of table?

A better way is to use SHOW KEYS since you don’t always have access to information_schema. The following works:

SHOW KEYS FROM table WHERE Key_name="PRIMARY"

Column_name will contain the name of the primary key.