inSUBJECTS
Triggers in MySQL
Triggers in MySQL A trigger is a stored program appealed automatically when an event such as insert, update, or delete occurs in the associated table. According to SQL, standard triggers are classified into two types of row-level triggers and statement-level triggers. A row-level trigger is activated when each row is inserted, updated, or deleted…
Read more
inSUBJECTS
Stored Function in mysql
MySQL Stored Function A stored function is a stored program that returns a single value. Basically specific code that performs specific operations and then returns a result. It is used to encapsulate common formulas or business rules. Reusable SQL statements or stored programs and reduce data inconsistencies. Different from a stored procedure.…
Read more
Social Plugin