Results 1 to 7 of 7
Thread: Auto_increment Problem
Feb 10, 2005, 23:38 #1
- Join Date
- Apr 2004
- 0 Post(s)
- 0 Thread(s)
i try to insert a row , but the problem is i want to insert the autoincrement value
to another filed in the inserted row. And this with only one Insert query.
Last_ID() doesnt work because it retrieve the previous id not the current one.
I've tried something like
INSERT INTO table SET ... , fieldname = autoincrementfieldname
but that doesn't work.
Any suggestion how i can achieve this with only one query?
The solutions with two queries i know already well. -> Dont suggest that plz.