MySQL – Triggers Table of content Generally, a Trigger is defined as a response to an event. In MySQL, a trigger is a special stored procedure that resides in the system catalogue, that is executed automatically (without being called explicitly like regular stored procedures) whenever an event is performed. These events include statements like INSERT, […]
Category Archives: mysql
MySQL – INT Table of content The MySQL INT Data Type The MySQL INT data type is used to store whole numbers without the decimal places (integers). However, MySQL provides various integer data types, such as TINYINT, SMALLINT, MEDIUMINT, and BIGINT to cater to different ranges of whole numbers. The following table illustrates the characteristics […]
MySQL – Inner Join Table of content MySQL Inner Join MySQL Inner Join is a type of join that is used to combine records from two related tables, based on common columns from both the tables. These tables are joined together on a specific condition. If the records in both tables satisfy the condition specified, […]