Hi,

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.

Greez Pozor