MYSQL Tutorial

MySQL is a very powerful program that can handle a large set of functionality of the most expensive and powerful database packages. MySQL is customizable because it is an open-source database, and the open-source GPL license facilitates programmers to modify the SQL software according to their own specific environment.

MYSQL is a widely used relational database management system (RDBMS).

•  It is free and open-source.
•  It is ideal for both small and large applications.

  Tutorial

• Intro
• RDBMS

  Basic Commands

• SELECT
• WHERE
• AND, OR, NOT
• ORDER BY
• INSERT INTO
• NULL Values
• UPDATE  
• DELETE  
• MIN and MAX  
• COUNT, AVG, SUM  
• LIKE  
• Wildcards  
• IN  BETWEEN  
• Aliases  
• Joins  
• INNER JOIN  
• LEFT JOIN  
• RIGHT JOIN  
• CROSS JOIN  
• Self Join  
• UNION  
• GROUP BY  
• HAVING  
• EXISTS  ANY, ALL  
• INSERT SELECT  
• CASE  
• Null Functions  
• Comments  
• Operators

  Database

• Create DB  
• Drop DB  
• Create Table  
• Drop Table  
• Alter Table  
• Constraints  
• Not Null  
• Unique  
• Primary Key  
• Foreign Key  
• Check  Default  
• Create Index  
• Auto Increment  
• Dates  
• View