>>>>> "Sheamus" == Sheamus Nulty <snulty@stripped> writes:
Sheamus> I'm running a query where I'm moving data from a temp table. To do this I'm
Sheamus> using insert in conjunction with select. i.e. insert into Orders (......)
Sheamus> select .. from temp where session_id='XYZ'
Sheamus> Now the insert works perfectly but the problem I'm having is that if I run
Sheamus> mysql_insert_id after this query it keeps coming back as 0. However, if I
Sheamus> change the query to something like insert into Orders (...) values (...)
Sheamus> then I get back the correct value for the auto incrementing field.
Sheamus> So is it the case that I can't use the top query to move the data. I'm
Sheamus> running mysql version 3.21.31 on solaris 2.51 .
The above problem is fixed in MySQL 3.22, so the 'easy' solution is to