MySQL Subquery
In this tutorial, we will learn about MySQL Subqueries. MySQL subquery is also called a nested query. It is a query nested inside another SQL query. The subquery
MySQL
MySQL
Database Users
The database has users with different rights and permissions who use it for different purposes. Some users retrieve data and some back it up.
Install MySQL Server on Linux
Install MySQL Server on Linux In this tutorial, we’ll be going through the steps to Install MySQL Server server on the Ubuntu Linux machine. MySQL is one of the most popular open-source relational database. In this series of installing LAMP ( Linux, Apache, MySQL server and PHP) stack components, the next step after installing Apache Webserver […]
Working with MySQL Command Line
Working with MySQL Command Line In this tutorial, we will learn basic steps involved working with the MySQL command line. The most basic way to work with MySQL is to connect to the database from the command prompt. You need to connect to a database to create tables, view data, etc. Let’s see how to […]
Entity-Relationship Model
In this tutorial, we will learn about relational database design using the most common entity-relationship model. An Entity-relationship Model (in short, ER model) describes
MySQL SELECT Statement
In this tutorial, we will learn MySQL SELECT statement with examples. The SELECT statement is used to retrieve data from the MySQL database.