Category Archives: mysql

MySQL – DECIMAL Table of content The MySQL Decimal Data Type The MySQL DECIMAL data type is used to store numeric values with decimal points. It allows for precise calculations and can be configured to store a specified number of digits before and after the decimal point. We often use this datatype for the columns […]

MySQL – Boolean Datatype Table of content A Boolean data type is used to represent truth values of logic and Boolean algebra. It has two possible values: either true or false. For example, if a customer wants to see all the bikes that are black in colour, we can filter them using BOOLEAN operator, as […]

MySQL – Composite Key Table of content A MySQL Composite Key is a key that consists of two or more columns in a table, used to uniquely identify a record (combination of values in the same table row). It can also be described as a Primary Key created on multiple columns. With composite key on […]