Hi guys
i'm with a doubt about the "standard" (sql standand?) error reporting , about INSERT SELECT...

should this insert select return duplicate key?
INSERT INTO errorsX (id) SELECT MAX(id)+1 FROM errorsX;


considering:
----
CREATE TABLE errorsX(
 id INT NOT NULL DEFAULT 0,
 PRIMARY KEY (id)
) ;
----

--
Roberto Spadim
SPAEmpresarial
Eng. Automação e Controle