MySQL

Case

Add a CCLIMIT Column on Customers with type number and create a trigger database send message as follows:

create table Customer SSN char (10) primary key, CustomerName varchar (40), DrivingLicense varchar (8), CustomerCreditCard char(16)) insert into Customer values ('3344556677', 'Ade Krisdianto', '89127622', '350'), ('1122334455', 'Pradana', ' 31920771 ', '200'), ('2211442244', 'Ahmad Sopian', '20011390', '500') SQL> Update Customer set CCLIMIT =200 Where SSN ='1122334455'; 23 _imit CC anda sudah ter update Sebesar 200 Pada tanggal 22-DEC-22