Re: how to convert sql trigger to mysql

[Omer Ahmed]

Dear i was not meaning that ... actually i am new in mysql. i was working in sql server but mysql is new to me and i have an urgent project to do thats why i am asking for a help in shape of coding of trigger. below is the DDL

CREATE TABLE `coaold` (
`autoid` int(11) NOT NULL AUTO_INCREMENT,
`txtid` varchar(45) DEFAULT NULL,
`coaid` varchar(45) DEFAULT NULL,
`accounttitle` mediumtext DEFAULT NULL,
`openingbalance` decimal(18,2) DEFAULT NULL,
`accountcategory` varchar(45) DEFAULT NULL,
`accountgroup` varchar(45) DEFAULT NULL,
`accounttype` varchar(45) DEFAULT NULL,
`entrydate` date DEFAULT NULL,
`FYEAR` varchar(45) DEFAULT NULL,
`username` varchar(45) DEFAULT NULL,
PRIMARY KEY (`autoid`),
KEY `autoid` (`autoid`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4

please if possible can you fix my trigger issue