Rich,
>How can I select primary key from a table?
To retrieve PKs for db.tbl in MySQL 5 ...
SELECT k.column_name
FROM information_schema.table_constraints t
JOIN information_schema.key_column_usage k
USING(constraint_name,table_schema,table_name)
WHERE t.constraint_type='PRIMARY KEY'
AND t.table_schema='db'
AND t.table_name='tbl';
Pre-5, parse the result of DESC tbl or SHOW KEYS FROM tbl.
PB
Rich wrote:
> 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)
>
>
>
> --MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
>
>
>
> --No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.1.411 / Virus Database: 268.17.37/682 - Release Date:
> 2/12/2007
>
>
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.411 / Virus Database: 268.17.37/682 - Release Date: 2/12/2007
