Re: getting primary key column name in mysql

[Paul McArdle]

SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.`COLUMNS` where TABLE_NAME = 'TABLENAME' AND COLUMN_KEY = 'PRI';