Welcome to the MySQL Knowledge Base and Tutorial
How to Change location Of MariaDB Data Directory
How to change location Of MariaDB Data Directory Safely. Here is the steps to follow migrate data directory to anotherRead More »
How to check partition details of MySQL table
Here, We can check the partition details of the MySQL table, like how many partitions are there in a tableRead More »
MySQL update table based on value of another table Join
While working on MySQL, sometimes we need to update the table values based on the values of another table. InRead More »
How to SUM Columns value in MYSQL
We require the sum of column values to display or use in the programming skill. So today you see HowRead More »
How to set up multi-master slave in MySQL
Today, We will see how to set up a multi-master slave in the MySQL replication process. Read more: Replication withRead More »
MySQL: How to ignore errors when importing data?
Recently, I faced an issue while importing data to MySQL. Here are the steps that help me to solve andRead More »
What is MariaDB and How to Install MariaDB On Windows
Today, We will learn the basics of MariaDB and Will also Download and install MariaDB on Windows. What is MariaDB?Read More »
SQL DEFAULT Constraint : add Default Value Into a Column
The DEFAULT constraint is used to set a default value for a column. In the below example City column has the defaultRead More »
MySQL CHECK Constraint
MySQL CHECK Constraint The CHECK the constraint is used to limit the value range that can be placed in a column. IfRead More »
MySQL PRIMARY KEY Constraint
MySQL PRIMARY KEY Constraint The PRIMARY KEY constraint uniquely identifies each record in a table. Primary keys must contain UNIQUE values, andRead More »
UNIQUE Constraint
UNIQUE Constraint The UNIQUE constraint ensures that all values in a column are different. Both the UNIQUE and PRIMARY KEY constraints provide a guarantee for uniquenessRead More »
MySQL - NOT NULL Constraint
NOT NULL Constraint By default, a column can hold NULL values. The “NOT NULL constraint” enforces a column to NOT acceptRead More »
MySQL Constraints
MySQL Constraints SQL constraints are used to specify rules for data in a table. The constraint in MySQL is usedRead More »
MySQL CREATE TABLE Statement
MySQL CREATE TABLE Statement The MySQL CREATE TABLE Statement The CREATE TABLE statement is used to create a new table in aRead More »
MySQL AUTO INCREMENT Field
MySQL AUTO INCREMENT Field What is an AUTO INCREMENT Field? Auto-increment allows a unique number to be generated automatically whenRead More »