How to change location Of MariaDB Data Directory Safely. Here is the steps to follow migrate data directory to another server. read more: How to check partition details of MySQL table Know more about Change default MySQL Data Directory in Linux You may require to change the MySQL data directory due to insufficient partition space … Read more
Here, We can check the partition details of the MySQL table, like how many partitions are there in a table and storage size of each partition? Know more about MYSQL Partitioning : What is and HOW To ? RANGE Partitioning in MySQL We can check this from the below query needs to run on any … Read more
While working on MySQL, sometimes we need to update the table values based on the values of another table. In this case, we can update the table value by joining from another table. MySQL table join Here, I have done this as follows: For example, we need to update the value to table2 from the … Read more
We require the sum of column values to display or use in the programming skill. So today you see How to SUM Columns value in MYSQL. Learn More: How to Select Data Into MySQL Database Using PHP ? How to Create Event Calendar with jQuery, PHP, and MySQL Problem Statement: subject | mark1 | mark2 … Read more
Today, We will see how to set up a multi-master slave in the MySQL replication process. Read more: Replication with Different Master and Slave Storage Engines Also Read: Reset ( Re-Sync ) MySQL Master-Slave Replication MariaDB 10 supports multi-source replication, and each MariaDB Galera node can have up to 64 masters connected to it. So … Read more
Recently, I faced an issue while importing data to MySQL. Here are the steps that help me to solve and ignore the error. Read more: show progress on MySQL DB Import Use the –force (-f) flag on your MySQL import. Rather than stopping on the offending statement, MySQL will continue and just log the errors … Read more
Today, We will learn the basics of MariaDB and Will also Download and install MariaDB on Windows. What is MariaDB? MariaDB is a fork of the MySQL database management system. It is created by its original developers. This DBMS tool offers data processing capabilities for both small and enterprise tasks. MariaDB is an improved version … Read more
The DEFAULT constraint is used to set a default value for a column. In the below example City column has the default value Sandnes CREATE TABLE Persons ( ID int NOT NULL, LastName varchar(255) NOT NULL, FirstName varchar(255), Age int, City varchar(255) DEFAULT ‘Sandnes’); The default value will be added to all new records if no other value is specified. Example of default constraint Example … Read more
MySQL CHECK Constraint The CHECK the constraint is used to limit the value range that can be placed in a column. If you define a CHECK constraint on a column it will allow only certain values for this column. If you define a CHECK constraint on a table it can limit the values in certain columns based on values in other … Read more
MySQL PRIMARY KEY Constraint The PRIMARY KEY constraint uniquely identifies each record in a table. Primary keys must contain UNIQUE values, and cannot contain NULL values. A table can have only ONE primary key; and in the table, this primary key can consist of single or multiple columns (fields). PRIMARY KEY on CREATE TABLE The following SQL … Read more