triggers Questions

How to convert value on tables with mysql into json file with trigger? – Phpmyadmin

January 2, 2019
fabios95
2 Answers

I use phpmyadmin for handle the mysql database. I have got a table that call NodeJS and the column of this table calls id and number. I tried to create a JSON file with this trigger on mysql: SELECT id,…

VIEW QUESTION

why is "else" on the trigger considered wrong? – Phpmyadmin

December 31, 2018
Samuel Ricky Saputro
2 Answers

I wrote the following code DELIMITER $$ CREATE TRIGGER bm_keuangan AFTER UPDATE ON pembayaran_project FOR EACH ROW BEGIN DECLARE nama_project varchar(100); DECLARE cek_di_keuangan varchar(100); IF (!(isnull(NEW.deleted_at))) THEN UPDATE keuangan SET keuangan.deleted_at = now() WHERE keuangan.ref = NEW.id AND keuangan.jk_id =…

VIEW QUESTION

Previous
Page 1
…
Page 6
Page 7
Page 8
Page 9