MySQL Tutorial

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 another
Read 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 table
Read 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. In
Read 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 How
Read 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 with
Read 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 and
Read 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 default
Read 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. If
Read 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, and
Read 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 uniqueness
Read 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 accept
Read More »

MySQL Constraints

MySQL Constraints SQL constraints are used to specify rules for data in a table. The constraint in MySQL is used
Read 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 a
Read 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 when
Read More »

Older Entries »