MySQL – SHOW TRIGGERS Table of content Triggers in MySQL are stored programs similar to procedures. These can be created on a table, schema, view and database that are associated with an event and whenever an event occurs the respective trigger is invoked. MySQL provides a statement to list out all the existing triggers present […]
Category Archives: mysql
MySQL – TINYINT Table of content The MySQL TINYINT Data Type The MySQL TINYINT data type is used to store integer values within a very small range. It occupies just 1 byte (8 bits) of storage and can hold values from -128 to 127 for signed TINYINT or 0 to 255 for unsigned TINYINT. When […]
MySQL – Left Join Table of content Unlike inner join, which provides the intersection values of two tables, there is another type of join called Outer Join. This outer join provides the collection of matched and unmatched records of two tables in multiple cases. MySQL Left Join Left Join is a type of outer join […]