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 <[email protected]> ha scritto: Oggetto: [Maria-discuss] Doubt about 'atomic' insert A: "Maria Discuss" <[email protected]> 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 : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
