https://selfimagination.in/tips
Developed by : Sandip Nigam

1. Terminology of MySQL

# Column 1 Column 2 Column 3
Row 1
Row 2
Row 3
Read More See Video

# Column 1 Column 2 Column 3
Row 1
Row 2
Row 3
Read More See Video

TRIM LTRIM RTRIM
UPPER LOWER UCASE LCASE
LEFT RIGHT SUBSTR LOCATE
LENGTH CONCAT CONCAT_WS
Read More See Video

DIV MOD ABS RAND
ROUND CEIL FLOOR TRUNCATE
POWER SQRT CONV
Read More See Video

DATE RELATED FUNCTION
CURDATE MAKEDATE DATE
DAYNAME MONTHNAME MONTH
ADDDATE DATEDIFF LAST_DAY
DATE_ADD DATE_SUB YEAR
TIME RELATED FUNCTION
CURTIME MAKETIME NOW
TIME_TO_SEC SEC_TO_TIME TIME
Read More See Video

COUNT
SUM
AVG
MIN
MAX
Read More See Video

COUNT() OVER()
SUM() OVER()
AVG() OVER()
MIN() OVER()
MAX() OVER()
Read More See Video

ROW_NUMBER
RANK DENSE_RANK PERCENT_RANK
FIRST_VALUE LAST_VALUE NTH_VALUE
NTILE LEAD LAG
Read More See Video

PARAMETER IN (OPTIONAL)
RETURN SINGLE VALUE
Read More See Video

PARAMETER IN
OUT
INOUT
Read More See Video

EVENT
TIME INSERT UPDATE DELETE
BEFORE
AFTER
Read More See Video

CLUSTERED INDEX
Primary Index
Unique Index or Unique
NON CLUSTERED INDEX
Simple Index or Index
Spatial Index (like Geo Columns)
FullText index (For Char, Varchar, Text)
Read More See Video

USER
User 1
User 2
User 3
DATABASE
Database 1
Database 2
Database 3
PRIVILAGES
ALL PRIVILEGES
CREATE
DROP
INSERT
UPDATE
DELETE
SELECT
.
.

2. MySQL Commands

# CREATE ALTER DROP
DATABASE
TABLE
INDEX

# CREATE ALTER DROP
VIEW
FUNCTION
PROCEDURE
TRIGGER

# TABLE PROCEDURE
INSERT
UPDATE
DELETE
CALL

GRANT
REVOKE

COMMIT
ROLLBACK