> 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
