MySQL

now browsing by category

 

Inner Join in MySQL

In this Article, I will let you know about Inner Join in MySQL. Inner Join :- Inner Join also known as Equi Join, Normal Join, it shows the only the result of two or more tables as condition satisfied. Let’s say we have two tables EMPLOYEE and DEPARTMENT Below isRead More

MySql Master Slave Replication Setup

In this article, I will let you know how to set up Master-Slave Replication in MySql. For this you should have two IPs, one for Master server and another one for Slave server. Consider we have the below two IPs for Master & Slave server. 10.10.19.20 – Master Server 10.10.19.22Read More

MySQL Connection

MySQL Connection using mysql binary: You can establish MySQL database using mysql binary at command prompt. Example: Here is a simple example to connect to MySQL server from command prompt: [root@host]# mysql -u root -p Enter password:****** This will give you mysql> command prompt where you will be able toRead More

What is MySQL?

MySQL is the most popular Open Source Relational SQL database management system. MySQL is one of the best RDBMS being used for developing web-based software applications. This tutorial will give you quick start with MySQL and make you comfortable with MySQL programming. MySQL is a freely available open source RelationalRead More