In this article I will explain how to Install MySQL Server on CentOS/ Redhat. MySQL server is the...
Category - Database
How to Change MySQL User Password
Question : I would like to change password for user called “neo” using MySQL command...
How to Enable Slow Query Log in MySQL 5.6
Compared to previous version in MySQL 5.6 they introduced different way for logging slow queries...
How to Change MySQL Data Directory to New Location on CentOS 7
Databases are constantly growing and it is likely to outgrow your / partition at some point...
How to Install MongoDB Server on Ubuntu and Debian Based System
MongoDB is an free and open source database which uses a document-oriented data model. MongoDB is a...
How to Install MySQL 8.0 on CentOS, RHEL and Fedora Systems
MySQL server is the most popular open source relational database management system (RDBMS). MySQL...
How to Disable Strict SQL Mode in MySQL 5.7
In this article I will show how you can disable strict SQL mode in MySQL 5.7 or later version...
Skip Duplicate Replication Error in MySQL
MySQL replication get stopped whenever “Duplicate entry” error comes. You can fix this...
Alter Table Statement in MySQL : How to Add Column in Table
MySQL Alter Table statement is used to add, modify, drop or delete column in a table you can also...
How to :- Alter Table or Add Multiple Columns in Table? –...
Guys In this article we will learn how we can Alter Table or Add Multiple columns in Table in MySQL...
Alter Table Statement in MySQL : How to Modify Column in Table
In this article I will show you how to add modify columns in table. MODIFY COLUMN IN TABLE Syntax...
Alter Table Statement in MySQL : How to Modify Multiple Columns...
In this article I will show you how to modify multiple columns in table. MODIFY MULTIPLE COLUMNS IN...
Alter Table Statement in MySQL : How to Drop Column in Table
In this article I will show you how to drop column in table. DROP COLUN IN A Table Syntax Follow...
Alter Table Statement in MySQL : How to Rename Column in Table
In this tutorial I will show you how to rename column in a table. RENAME COLUMN IN A TABLE Syntax...