INSERT SELECT is not standard SQL. But there is no reason to have a duplicate value error. Regards Federico -------------------------------------------- Sab 13/12/14, Roberto Spadim <roberto@spadim.com.br> ha scritto: Oggetto: [Maria-discuss] Doubt about 'atomic' insert A: "Maria Discuss" <maria-discuss@lists.launchpad.net> Data: Sabato 13 dicembre 2014, 19:13 Hi guysi'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 SPAEmpresarialEng. Automação e Controle -----Segue allegato----- _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp