mysql inserted表,如何在MySql中获取Inserted值Id？

Hi,

How to Get Inserted value Id in MYSQL.

I am using " select LAST_INSERT_ID() " But its not working Properly.Can u provide any other solution For this.Please Help me.

Thanks & Regards

Madhava Reddy.

解决方案When the id is auto-generated by the server, you must not include it in the insert query (I am not sure with current versions of MySQL, but with old versions, you could supply 0 instead of omitting it completely).

Hi you can try out like this by storing the last inserted id in a variable.

Insert into Tbl(id,name,sal)values(_id,_name,_sal);

SET @last_inserted_id = LAST_INSERT_ID();

select id,name,sal from Tb1 where id=@last_inserted_id;

Hope it would be useful.

Hai

ur question is not clear,in which application u need to use select query ? web or windows ?

anyway u can try this,when u going to insert definitely u pass the values(like unique id,name ect) to insert query,so pass that unique id or name in session(if it is web) or public variable(if it is windows) and use that session or public variable in Select query.

Or u use autoincrement in ur table and select last id from table using select query