maria-discuss team mailing list archive

[Roberto Spadim <roberto@xxxxxxxxxxxxx>]

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