MySQL – CREATE TRIGGER Table of content Triggers are generally defined as responses to an event. For instance, when we hover a mouse-pointer on a drop-down menu of a website, a various set of options to navigate through this website are then displayed. Here, the hovering of the mouse-pointer is an event while the display […]
Category Archives: mysql
MySQL – BIT Table of content A bit represents the basic unit of data in programming languages. It can store only two values, represented as 0 or 1. The MySQL BIT Data Type The MySQL BIT data type is used to store binary values within a specified range. The range is determined by the number […]
MySQL – Interval Operator Table of content MySQL INTERVAL Operator The INTERVAL operator in MySQL is used to create an interval between two different events or times. This interval can be in seconds, minutes, hours, days, etc. Thus, MySQL mainly uses this operator to perform date and time calculations, such as adding or subtracting a […]