Hi Thiyaghu,
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: theyaho...@gmail.com > To: tx...@hotmail.com > CC: mysql@lists.mysql.com > > Hi, > > Use > > *SELECT * FROM game_log WHERE this_table's_PK = last_insert_id()* > > It will help you. > > Regards, > Thiyaghu CK, > MySQL DBA > www.mafiree.com > > 2010/2/1 曹凯 <tx...@hotmail.com> > > > > > 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 _________________________________________________________________ 约会说不清地方?来试试微软地图最新msn互动功能! http://ditu.live.com/?form=TL&swm=1