[AccessD] Arthur - MYSQL

All i know is from the SQL prompt: show fields from yourtablename
And using PHP: $query  = "select * from yourtablename";
                        $result = mysql_query($query);
                        itterate trough the result and with
                        mysql_field_flags($result, number) you can see which
column is the primary key.

HTH

Bert-Jan

----- Original Message -----
From: <Mwp.Reid at queens-belfast.ac.uk>
To: <accessd at databaseadvisors.com>
Sent: Monday, April 21, 2003 9:47 PM
Subject: [AccessD] Arthur - MYSQL


> Arthur
>
> Change of plan
>
> I need the sql statement to find out which is the PK in MySQL something
like
>
> SELECT * FROM
> databaseName.INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE
>
> Martin
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com