Re: Does 'insert' return a value?

2006-10-24 Thread Martijn Tonies
the insert return a value that where the record have been inserted into? What do you mean by where the record have been inserted into? The physical position? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: Does 'insert' return a value?

2006-10-24 Thread Chris
Martijn Tonies wrote: No,I mean the position of the recorde in the table In the SQL world, records don't have a position in a table. When you request data, you will get a resultset, not access to a table. The resultset is derived from the actual table data. He wants the last_insert_id

Does 'insert' return a value?

2006-10-23 Thread 黄小聪
When I insert a record into a table Does the insert return a value that where the record have been inserted into?

Re: Does 'insert' return a value?

2006-10-23 Thread Chris
黄小聪 wrote: When I insert a record into a table Does the insert return a value that where the record have been inserted into? No. You need to select last_insert_id() or use a function in your programming language (eg php has php.net/mysql_insert_id). -- MySQL General Mailing List For list

Re: Does 'insert' return a value?

2006-10-23 Thread Martijn Tonies
When I insert a record into a table Does the insert return a value that where the record have been inserted into? What do you mean by where the record have been inserted into? The physical position? Martijn Tonies Database Workbench - development tool for MySQL, and more! Upscene