I have already got the last_insert_id. now I wanna know if there are any variables or
constants to instead of game_log's primary key cos I don't know its name.
> Date: Mon, 1 Feb 2010 14:24:59 +0530
> Subject: Re: how to get the name of primary key ?
> From: theyahoock@stripped
> To: txdyc@stripped
> CC: mysql@stripped
> *SELECT * FROM game_log WHERE this_table's_PK = last_insert_id()*
> It will help you.
> Thiyaghu CK,
> MySQL DBA
> 2010/2/1 曹凯 <txdyc@stripped>
> > Hi all,
> > if we just know the table name but don't know the name of primary key, is
> > there any variables or constants could instead of the PK?
> > for example:
> > there is a table "game_log", and now I have the last inserted_id but don't
> > know what its primary_id is,
> > how can I "SELECT * FROM game_log WHERE this_table's_PK =
> > last_inserted_id"?
> > _________________________________________________________________
> > 约会说不清地方？来试试微软地图最新msn互动功能！
> > http://ditu.live.com/?form=TL&swm=1