[Maria-discuss] R: Doubt about 'atomic' insert

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 ha scritto: Oggetto: [Maria-discuss] Doubt about 'atomic' insert A: "Maria Discuss" 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