From: Steffan A. Cline
Date: January 12 2007 1:03pm
Subject: Re: Primary key
List-Archive: http://lists.mysql.com/mysql/204385
Message-Id: <C1CCD53E.55F7F%steffan@hldns.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="US-ASCII"
Content-Transfer-Encoding: 7bit

> In the last episode (Jan 11), Steffan A. Cline said:
>> Is there anyway to do a SELECT or DESCRIBE or SHOW statement which can
>> return the primary key field of a specified table?
>> 
>> Pseudo code: select primary_key_field_name from mytable.
> 
> SELECT * FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE
>   WHERE TABLE_SCHEMA='myschema' AND TABLE_NAME='mytable'
>   AND CONSTRAINT_NAME='PRIMARY'
>   ORDER BY ORDINAL_POSITION;
> 
> For multi-column indexes, you will get multiple rows back.
> 
> You should also use "show create table mytable" or "show keys from
> mytable" but you'll have to do extra parsing.

Dan,

Great! This is what I was after... I am building a class/ctype for Lasso for
a user db. When it is instantiated, it loads the structure into the type
from the db. Now, I have the primary key as the ID of the type I need to
separate it from the rest of the columns. SO, I guess now I'll work on
unless you have it handy where I can return all columns EXCEPT the primary
key.

Thanks

Steffan

---------------------------------------------------------------
T E L  6 0 2 . 5 7 9 . 4 2 3 0 | F A X  6 0 2 . 9 7 1 . 1 6 9 4
Steffan A. Cline
Steffan@stripped                             Phoenix, Az
http://www.ExecuChoice.net                                  USA
AIM : SteffanC          ICQ : 57234309
                                  Lasso Partner Alliance Member
---------------------------------------------------------------



> From: Dan Nelson <dnelson@stripped>
> Date: Fri, 12 Jan 2007 01:00:03 -0600
> To: "Steffan A. Cline" <steffan@stripped>
> Cc: <mysql@stripped>
> Subject: Re: Primary key
> 
> In the last episode (Jan 11), Steffan A. Cline said:
>> Is there anyway to do a SELECT or DESCRIBE or SHOW statement which can
>> return the primary key field of a specified table?
>> 
>> Pseudo code: select primary_key_field_name from mytable.
> 
> SELECT * FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE
>   WHERE TABLE_SCHEMA='myschema' AND TABLE_NAME='mytable'
>   AND CONSTRAINT_NAME='PRIMARY'
>   ORDER BY ORDINAL_POSITION;
> 
> For multi-column indexes, you will get multiple rows back.
> 
> You should also use "show create table mytable" or "show keys from
> mytable" but you'll have to do extra parsing.
> 
> -- 
> Dan Nelson
> dnelson@stripped