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
