MySQL Forums
Forum List  »  Other Migration

Re: how to convert sql trigger to mysql
Posted by: Omer Ahmed
Date: July 15, 2022 10:22PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: how to convert sql trigger to mysql
194
July 15, 2022 10:22PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.