MySQL DBA

MySQL Users

create user
show users
change password
grant previlaes
show prvilages
revoke privailages
lock user account
unlock account

create tables
1. basic
2. IF NOT EXISTS clause
3. Table from an Existing Table
3.1 with data and schema
3.2 only schema

show tables
show columns

Alert tables

1.adding column
2.delete column
3.Repositioning a Column--after column name or first
4.modify columns data types
5.rename table name using alter table and without alter table
6.rename column name usng alter

trucate tables
describe tables
add/delete row in tables
drop tables
derived tables

MySQL Constraints

1.Column level constraints:
1.1 NOT NULL
1.6 DEFAULT
1.7 AUTO_INCREMENT

2.Table level constraints:

2.1 UNIQUE
2.2 PRIMARY KEY Constrain
2.3 FOREIGN
2.4 CHECK

MySQL Insert Query
1.1 Basic
1.2 Inserting Data Into a Table Using Another Table
1.3 INSERT ... SET
1.4 INSERT INTO CUSTOMERS_Copy SELECT * from CUSTOMERS;
1.5 INSERT INTO table1 TABLE table2;
1.6 Insert Ignore Statement
1.7 Insert on Duplicate Key Update Statemen
1.8 INSERT INTO... SELECT column
1.9 Inserting records using REPLACE statement

MySQL WHERE Clause
MySQL Limit Clause
MySQL DISTINCT clause
MySQL ORDER BY Clause
MySQL GROUP BY Clause
MySQL Having Clause
MySQL AND Operator
1.0 AND operator with WHERE
1.1 AND with UPDATE statement
1.2 AND with DELETE Statement

MySQL OR Operator
1.0 OR operator with WHERE
1.1 OR with UPDATE statement
1.2 OR with DELETE Statement

MySQL LIKE Operator
1.0 Using LIKE Operator with Wildcards
1.1 Using LIKE Operator with AND/OR Operators
1.3 Using NOT Operator with LIKE Operator

MySQL In Operator
1.0 basic
1.1 IN Operator in UPDATE statement
1.2 NOT IN operator

ANY Operator in MySQL

MySQL NOT Operator
1.0 NOT with IN Operator
1.1 NOT with IS NULL Operator
1.2 NOT with LIKE Operator
1.3 NOT with BETWEEN Operator
1.4 NOT with UPDATE Statement
1.5 NOT with DELETE Statement

MySQL NOT EQUAL Operator <> !=

MySQL IS NULL Operator
IS NOT NULL Operator
MySQL - Between Operator
1.0 MySQL BETWEEN with IN Operator
1.1 BETWEEN with UPDATE statemenr
1.2 BETWEEN operator with DELETE statement

MySQL Joins

MySQL Inner Join
MySQL Left Join
MySQL Right Join
MySQL Cross Join
MySQL Full Join
MySQL Self Join

Date Time functions

SELECT CURDATE();
CURTIME();
Date()
DATEDIFF()
DAY()

MySQL - Regular Expressions
MySQL - NOT REGEXP Operator