I am using mysql 5 and mysql query browser 1.1.15
Code:DROP TABLE IF EXISTS `mindsolutions`.`encomendas`; CREATE TABLE `mindsolutions`.`encomendas` ( `numenc` int(10) unsigned NOT NULL auto_increment, `cliente` varchar(45) NOT NULL, `dataabertura` datetime NOT NULL, `designacao` varchar(255) NOT NULL, `obs` varchar(255) default NULL, `preco` decimal(10,0) NOT NULL, `estado` varchar(45) default '', `documentacao` varchar(255) default NULL, `responsavel` varchar(45) default '', PRIMARY KEY (`numenc`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;error:Code:delimiter$$ CREATE PROCEDURE mindsolutions.grava_encomenda (in numenc int(10), in cliente varchar(45) , in dataabertura datetime , in designacao varchar(255), in obs varchar(255), in preco decimal(10,0), in estado varchar(45) , in documentacao varchar(255), in responsavel varchar(45)) BEGIN if not exists (select * from mindsolutions.encomendas where numenc = numenc); insert into mindsolutions.encomendas values(numenc,cliente,dataabertura,designacao,obs,preco,estado,documentacao,responsavel); END$$ delimiter;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the rigth syntax near ';insert into mindsolutions.encomendas values(numenc,cliente,dataabertura,des' at line 3
Any suggestion?
Regards
Jorge


Reply With Quote
