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
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
When I insert a record into a table
Does the insert return a value that where the record have been inserted
into?
黄小聪 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
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