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 […]
Category Archives: mysql
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, […]
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 […]