MYSQL
SQL stands for Structured Query Language. It is a
computer language for storing, manipulating and
retrieving data stored in a relational database.
SQL is the standard language for Relational
Database System. All the Relational Database
Management Systems (RDMS) like MySQL, MS
Access, Oracle, Sybase, Informix, Postgres and
SQL Server use SQL as their standard database
language.
MySQL is the most popular Open Source SQL
database management system. The MySQL
Database Server is very fast, reliable, scalable,
and easy to use.
Open Source means that it is possible for anyone
to use and modify the software. Anybody can
download the MySQL software from the Internet
and use it without paying anything.
CREATE AND USE DATABASE
TO CREATE TABLE
TO INSERT DATA
TO VIEW THE TABLE
SIMPLE SELECT
USING DISTINCT CLAUSE
CONDITIONAL SELECT USING WHERE CLAUSE
USING ORDER BY CLAUSE
USING BETWEEN OPERATOR
USING LIKE OPERATOR
USING IS OPERATOR
USING IS NOT OPERATOR
MYSQL FUNCTIONS
1.TEXT/STRING FUNCTIONS
➢ Upper
➢ Lower
➢ Substr
➢ Rtrim
➢ Ltrim
➢ Trim
➢ Length
➢ Instr
➢ Left
➢ Right
➢ Mid
2.NUMERIC FUNCTIONS
➢ Mod
➢ Power
➢ Round
3.DATE FUNCTIONS
➢ Date( )
➢ Day( )
➢ Month( )
➢ Year( )
➢ Month name( )
➢ Day name( )
➢ Now( )
4.AGGREGATE FUNCTIONS
➢ Avg
➢ Count
➢ Sum
➢ Min
➢ Max
USING GROUP BY CLAUSE
USING GROUP BY WITH HAVING CLAUSE
TO VIEW TABLE STRUCTURE
ALTERING TABLES
1.MODIFY
2.CHANGE
3.ADD
MODIFYING TABLES
VIEW THE TABLE AFTER CHANGES
DELETING DATA FROM TABLES
DROPING TABLES
