how to execute SP with TZSQLProcessor
Posted: 20.11.2012, 09:53
please help me,
how to execute this script with TZSQLProcessor because its failed caused by string delimiter $$
and default is ;
how to execute this script with TZSQLProcessor because its failed caused by string delimiter $$
and default is ;
drop table if exists mastergudangx;
CREATE TABLE `mastergudangx` (
`kd_gdg` varchar(20) NOT NULL,
`nm_gdg` varchar(20) NOT NULL,
`keterangan` varchar(30) DEFAULT NULL,
`kd_subdist` varchar(15) NOT NULL,
PRIMARY KEY (`kd_gdg`),
KEY `Index_mastergudangx_kd_subdist` (`kd_subdist`,`kd_gdg`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 PACK_KEYS=0;
DELIMITER $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_update_tglpjp`()
BEGIN
replace into mastersetting select 'tglpjp', setting from mastersetting where nama_setting='tglgudang';
END $$
DELIMITER ;