SELECT column_name
FROM INFORMATION_SCHEMA.`KEY_COLUMN_USAGE` 
 WHERE table_name='TABLENAME' 
 AND CONSTRAINT_SCHEMA='DBNAME'
 AND constraint_name='PRIMARY'