Triggers "use" whatever code you put in them.
Recommendations for what?
> -Original Message-
> From: Aastha [mailto:aast...@gmail.com]
> Sent: Friday, May 10, 2013 11:55 AM
> To: mysql@lists.mysql.com
> Subject: Triggers
>
> If triggers use complex business rules and large transaction.
>
A bit more readable:
select (mod(dayofweek(`Query1`.`Appointment_Date`)+7-1,7)),
{fn CONCAT({fn CONCAT({fn CONCAT(cast(extract(hourfrom
`Time_Difference_Query`.`Created_Date`) as char(25)),':')},
cast(extract(minute from `Time_Difference_Query`.`Created_Date`) as
char(25)))},':')},
Your question is far too vague to answer.
What are your requirements? What considerations are you worried about?
On Fri, May 10, 2013 at 2:55 PM, Aastha wrote:
> If triggers use complex business rules and large transaction.
> What would we be recommendations?
> I need three possible ways.
>
>
If triggers use complex business rules and large transaction.
What would we be recommendations?
I need three possible ways.
Thanks,
>
> 1. MyISAM locks _tables_. That can cause other connections
> to be blocked. Solution: switch to InnoDB. Caution: There
> are a few caveats when switching; see
> https://kb.askmonty.org/en/converting-tables-from-myisam-to-innodb/
>
> 2. As mentioned by Shawn, the Query Cache can be more
