As the subject line says:

Do triggers work on dbfiddle with MySQL 5.6.

I can get it working on my local machine but not on the fiddle site.

Here's what I don't appear to be able to get working.


```
root@localhost [test]> DESC payment_ter;
+-------------+------------------------+------+-----+---------+----------------+
| Field       | Type                   | Null | Key | Default | Extra          |
+-------------+------------------------+------+-----+---------+----------------+
| id          | int unsigned           | NO   | PRI | NULL    | auto_increment |
| price       | decimal(10,2) unsigned | NO   |     | 0.00    |                |
| pay_date    | int unsigned           | NO   |     | NULL    |                |
| pt_date_str | char(10)               | YES  |     | NULL    |                |
+-------------+------------------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)

root@localhost [test]> 
```

and


```
root@localhost [test]> SHOW TRIGGERS;
Empty set (0.00 sec)

root@localhost [test]>
```


My trigger:

```
DROP TRIGGER IF EXISTS tr_ins_dates;
DELIMITER $$ 
CREATE TRIGGER tr_ins_dates BEFORE INSERT 
  ON payment_ter 
      FOR EACH ROW BEGIN  
      SET NEW.pt_date_str = CONCAT_WS ('-', YEAR(FROM_UNIXTIME(NEW.pay_date)), 
                                    LPAD(MONTH(FROM_UNIXTIME(NEW.pay_date)), 2, 0), '01');
      END  $$ 
DELIMITER ;
```

and then I do an `INSERT`


```
root@localhost [test]> INSERT INTO payment_ter (price, pay_date) VALUES (56.6, UNIX_TIMESTAMP('2020-03-19 16:42:30'));
Query OK, 1 row affected (0.19 sec)
```

and then:

```
root@localhost [test]> SELECT * FROM payment_ter;
+----+-------+------------+-------------+
| id | price | pay_date   | pt_date_str |
+----+-------+------------+-------------+
|  1 | 56.60 | 1584636150 | 2020-03-01  |
+----+-------+------------+-------------+
1 row in set (0.00 sec)

```

So, my pt_date_str field has been updated - my trigger is working.

But, when I perform the same actions on dbfiddle, it won't work.

Here's a [link](https://dbfiddle.uk/?rdbms=mysql_5.6&fiddle=c8dcbb6cdc139b710b18bfdf2f1e2fb6) in case I'm missing something blindingly obvious!