SQL select from last inserted
- by arik-so
Hello,
in MySQL, I have table. One column has auto-increment. When I insert something
mysql_query('INSERT INTO `table` SET `column` = "data";');
Now, what I want is, without further queries, to get the value of the auto-incrementing column, maybe like this:
mysql_query('insertion = (INSERT INTO `table` SET `column` = "data");
SELECT `auto_incrementing_column` FROM `table`.insertion');
Please tell me how something like that is done. Thanks in advance!
