Database Dump And Issue With Timestamp Column Data No Treated As A Str

[jonb2]

PS.

A. I have just checked Heidi, it does what I want. It saves the edit.

'ashwin' wrote:

@jonb2.. We checked with HeidiSQL. Yes, they do allow to edit and save trigger. But..on SAVE they execute these queries(Checked from their query LOG)-

Code:

DROP TRIGGER `customer_create_date`;
/* 0 rows affected. */
CREATE DEFINER=`root`@`localhost` TRIGGER `customer_create_date` BEFORE INSERT ON `customer` FOR EACH ROW SET NEW.create_date = NOW();

Now, with SQLyog when you do Execute All these queries are executed-

Code:

DROP TRIGGER /*!50032 IF EXISTS */ `customer_create_date`;
CREATE ;

Priority fix, of course!

[ashwin]

We have fixed and released v10.41. Refer: http://blog.webyog.com/2012/11/21/sqlyog-mysql-gui-10-41-released/

[treadmill]

Fantastic, thank you very much for such a quick fix release. 🙂

[Author]

Posts