In this post, you’ll learn three main logical operators used to filter data in MySQL database. The three logical operators we will look into are: AND, OR and NOT operators. […]
Tag: sql
Filter Data in MySQL Using IN, BETWEEN and LIKE Logical Operators
Logical operators in MySQL are used to manipulate or combine Boolean conditions in SQL select statement (queries). Logical operators are essential for filtering data in WHERE clauses, joining conditions, and […]
Foreign & Candidate Keys in SQL Table
A foreign key is simply a primary key of another table in a table. A foreign key is an entity (column) (or a set of entities (columns)) in a table […]
How to Set Default Value in SQL
A Default Value in SQL (Structural Query Language) is a value set to be automatically assigned to a column if no value is specified when a new row is inserted […]
CRUD Operations in SQL Database Explained
In SQL, CRUD operation is the four basic operation used to manage and manipulate data in a relational database. CRUD stands for: C – create or insert, R – read […]
Data Types in SQL Database
In SQL (Structured Query Language) database there are various data types to determine the kind of value that can be stored in a column or field of a table. Below […]