mysql - Show primary key column in table -

i have following query

    use  recipesexample;      select recipes.recipetitle      recipes 

the create table is:

create table recipes (         recipeid int not null default 0 ,         recipetitle nvarchar (255) null ,         recipeclassid smallint null default 0 ,         preparation text null ,         notes text null );  alter table recipes          add constraint recipes_pk primary key          (                 recipeid         ); 

which outputs:

how edit query can view primary key? , foreign key recipeclassid.

simply add required columns in query comma separated,

select recipes.recipeid,recipes.recipeclassid,recipes.recipetitle recipes