MySQL Tutorials 14 Lessons

MySQL Tutorial

MySQL is the most popular RDBMS (Relational Database Management System) used to store data of web applications. This MySQL tutorial series will help you to get started in MySQL. You will learn the basics of MySQL and will be able to use the MySQL database easily.

    MySQL Introduction

    MySQL is an open-source, fast reliable, and flexible relational database management system, typically used with PHP. This chapter is an introductory chapter about MySQL, what is MySQL, and the main features of MySQL are described here.

      MySQL Setup

      This MySQL installation chapter explains how to install MySQL on Windows and Linux operating systems.

        MySQL Connect with PHP

        MySQL can be used with many languages, including C, C ++, JAVA, and PHP. In these languages, MySQL is most commonly used in PHP web development.

          MySQL PHP Syntax

          PHP provides various functions to access the MySQL database and to handling data records inside the MySQL database. This lesson describes PHP Syntax related to MySQL.

            MySQL INSERT INTO

            This lesson describes MySQL “INSERT INTO” query statement to insert data in a database.

              MySQL SELECT

              This lesson describes MySQL “SELECT” query statement to select data from a database.

                MySQL WHERE

                This lesson describes MySQL “WHERE” query statement to select data from a database with selection criteria.

                  MySQL ORDER BY

                  This lesson describes MySQL “ORDER BY” query statement to select data from a database with ascending or descending order.

                    MySQL UPDATE

                    This lesson describes MySQL “UPDATE” query statement to update data in a database table.

                      MySQL DELETE

                      This lesson describes MySQL “DELETE” query statement to delete data from database table.

                        Scroll Back to Top