My insert query look like your
'INSERT INTO ordinit(ID_ordine, Cod_Cliente) VALUES (NULL, 10);';
after the query I look into the table 'ordinit' and always looks fine: the value of
ID_ordine is really incremented.
But the following 'select LAST_INSERT_ID()' return zero :-((
It looks like a bug ?
Best regards.
>What does your INSERT query look like? It should specify NULL
>for ID_ordine, e.g.:
>INSERT INTO ordinit(ID_ordine, Cod_Cliente) VALUES (NULL, 10);
>Any other value for ID_ordine will not assign an auto_increment
>value.