MySQL Lists: mysql: Select Primary Key

List:	General Discussion	« Previous Message Next Message »
From:	Rich	Date:	February 12 2007 8:08am
Subject:	Select Primary Key
View as plain text

Hi folks.  How can I select primary key from a table?  I can't find  
any syntax out of show fields from tablename, and the 'key' field =  
"PRI".  Just seems to be a bit much.

Any takers?

Cheers


Rich in Toronto (cold)

Thread
• Select Primary Key	Rich	12 Feb
• Re: Select Primary Key	Peter Brawley	12 Feb