MySQL is a relational database management system based on SQL – Structured Query Language. The application is used for a wide range of purposes, including data warehousing, e-commerce, and logging applications. The most common use for mySQL however, is for the purpose of a web database.

MY SQL Modules

My SQL

• MySQL Intro
• MySQL RDBMS

MySQL SQL

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

MySQL Database

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

MySQL References

• MySQL Data Types
• MySQL Functions

My SQL FAQ's

Difference Between SQL and My SQL?

SQL is a query language, whereas MySQL is a relational database that uses SQL to query a database. You can use SQL to access, update, and manipulate the data stored in a database. ... SQL is used for writing queries for databases, MySQL facilitates data storing, modifying, and management in a tabular format.

Is SQL easy to learn?

It is not really difficult to learn SQL.
SQL is not a programming language, it's a query language. ... It is also an English like language so anyone who can use English at a basic level can write SQL query easily. The good news is that most DB engines are compatible with all SQL code.

Is Python Better than SQL?

SQL is good at allowing you as a developer, to seamlessly join (or merge) several data together. ... Python is particularly well suited for structured (tabular) data which can be fetched using SQL and then require farther manipulation, which might be challenging to achieve using SQL alone.

Can i use python instead of My SQL?

However, you cannot use SQL exclusively for performing higher-level data manipulations and transformations like regression tests, time series, etc. Python's specialized library, Pandas, facilitates such data analysis. Therefore, you can use SQL to fetch data and further manipulate the structured data using Python.