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.