Re: Returning values from an INSERT

2006-02-12 Thread Jonathan Mangin
- Original Message - From: bob pilly [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Sunday, February 12, 2006 12:44 AM Subject: Returning values from an INSERT Hi everyone, im new to SQL and have a question that someone can hopefully answer If i am inserting a new record

Returning values from an INSERT

2006-02-11 Thread bob pilly
Hi everyone, im new to SQL and have a question that someone can hopefully answer If i am inserting a new record into a table that has an auto_increment field in it, is it possible to get the value of that field returned automatically instead of having to do a SELECT.. For example my

Re: Returning values from an INSERT

2006-02-11 Thread Michael Stassen
bob pilly wrote: Hi everyone, im new to SQL and have a question that someone can hopefully answer If i am inserting a new record into a table that has an auto_increment field in it, is it possible to get the value of that field returned automatically instead of having to do a SELECT..