MySqlTutorials, MySql Articles, Learn MySql
- SQL Introduction in MySql
SQL Stands for Structured Query Language, it is used to created and edit databases, also used to create queries, forms, and reports - Basics of SQL Statement in MySql
Most of action you need to perform with sql statement, for example you need to retrieve data from a table tutorial, you need to use following statement. - SQL Select Statement in MySql
In this tutorial, we will learn select statement, the select statement is used to retrieve data from a table. - SQL Select Distict Statement in MySql
In this tutorial, we will learn select distinct statement - SQL Where Clause in MySql
The WHERE clause limits the rows retrieved to those meeting the search condition. - SQL And Or Operator in MySql
The AND & OR operators are used to filter records based on more than one condition. - SQL Order by Clause in MySql
The ORDER BY statement orders the returned values by the specified column(s) in Ascending or descending. - SQL Insert into statement in MySql
The INSERT INTO statement is used to insert a new record in a table - SQL Update statement in MySql
We can update existing records in a tables using UPDATE statement. - SQL Delete Statement in MySql
We can delete existing records in a tables using Delete statement. - SQL Delete and Drop table in MySql
The CREATE DATABASE statement creates a new database. Many different options can be... - SQL Create table Statement in MySql
The CREATE TABLE statement creates a new table within a database. - SQL Alter table statement in MySql
The ALTER TABLE statement is used to add, delete, or modify columns in an existing table. - Sql Drop Table and truncate table Statement in MySql
The DROP TABLE statement is used to delete a table. - Foreign Key Constraints in MySql
A FOREIGN KEY in one table points to a PRIMARY KEY in another table. - Primary Key Constraints in MySql
A primary key is used to uniquely identify each row in a table - Unique Key Constraints in MySql
The UNIQUE constraint ensures that all values in a column are distinct - SQL Functions in MySql
SQL has many built-in functions for performing calculations on data.
1
