Re: MyISAM/Blackhole Auto Increment Value Question

[Ingo Strüwing]

I wonder why you selected data from 'b' to verify the success of the insert statements ("SELECT * FROM `b`;"), but did not try the same with 'a' ("SELECT * FROM `a`;").

You probably would notice an empty result set. Nothing has been inserted (it's a black hole or no-operation table, nothing happens on it). Hence there is no insert id.

"SELECT LAST_INSERT_ID();" does not have a table reference. Hence it gives the last insert id created by the current session. And the last insert that happened was that for table 'b'.

Ingo Strüwing, Senior Software Developer - Storage Engines
MySQL AB, www.mysql.com