MySQL Tutorials

Welcome to MySQL Tutorials by ProgramGuru.org. We shall cover MySQL Databases, MySQL Tables, operations on Table rows and columns, etc., with examples.

Databases

  1. MySQL CREATE DATABASE Statement
  2. MySQL SHOW DATABASES Statement
  3. MySQL DROP DATABASE Statement

Tables

  1. MySQL CREATE TABLE Statement
  2. MySQL SHOW TABLES Statement
  3. MySQL ALTER TABLE Statement
  4. MySQL RENAME TABLE Statement
  5. MySQL TRUNCATE TABLE Statement
  6. MySQL DESCRIBE TABLE Statement
  7. MySQL DROP TABLE Statement
  8. MySQL TEMPORARY TABLE Statement
  9. MySQL Copy Table Statement
  10. MySQL ADD COLUMN Statement
  11. MySQL DELETE COLUMN Statement
  12. MySQL SHOW COLUMNS Statement
  13. MySQL RENAME COLUMN Statement

Table Rows

  1. MySQL INSERT Row(s) Statement
  2. MySQL SELECT Row(s) Statement
  3. MySQL UPDATE Row(s) Statement
  4. MySQL REPLACE ROW Statement
  5. MySQL DELETE Row(s) Statement
  6. MySQL DELETE ALL ROW(s) Statement

Clauses

  1. MySQL WHERE Clause
  2. MySQL DISTINCT Keyword
  3. MySQL ORDER BY Clause
  4. MySQL GROUP BY Clause
  5. MySQL HAVING Clause

MySQL Operators

Arithmetic Operators

  1. MySQL Addition Operator
  2. MySQL Minus Operator
  3. MySQL Multiplication Operator
  4. MySQL Division Operator
  5. MySQL Integer Division
  6. MySQL Modulo

Logical Operators

  1. MySQL AND Operator
  2. MySQL OR Operator
  3. MySQL NOT Operator
  4. MySQL Logical XOR Operator

Comparison Operators

  1. MySQL Equal To Operator
  2. MySQL Not Equal Operator
  3. MySQL Greater Than Operator
  4. MySQL Less Than Operator
  5. MySQL Greater Than or Equal To Operator
  6. MySQL Less Than or Equal To Operator
  7. MySQL NULL Safe Equal To Operator
  8. MySQL BETWEEN AND Operator
  9. MySQL COALESCE() Function
  10. MySQL GREATEST() Function
  11. MySQL IN Operator
  12. MySQL INTERVAL() Function
  13. MySQL IS Operator
  14. MySQL IS NOT Operator
  15. MySQL IS NULL Operator
  16. MySQL IS NOT NULL Operator
  17. MySQL ISNULL() Function
  18. MySQL LEAST() Function
  19. MySQL LIKE Operator
  20. MySQL NOT BETWEEN AND Operator
  21. MySQL NOT IN Operator
  22. MySQL NOT LIKE Operator

String Functions

  1. MySQL ASCII() String Function
  2. MySQL BIN() String Function
  3. MySQL BIT_LENGTH() String Function
  4. MySQL CHAR() String Function
  5. MySQL CHAR_LENGTH() String Function
  6. MySQL CHARACTER_LENGTH() String Function
  7. MySQL CONCAT() String Function
  8. MySQL CONCAT_WS() String Function
  9. MySQL ELT() String Function
  10. MySQL EXPORT_SET() String Function
  11. MySQL FIELD() String Function
  12. MySQL FIND_IN_SET() String Function
  13. MySQL FORMAT() String Function
  14. MySQL FROM_BASE64() String Function
  15. MySQL HEX() String Function
  16. MySQL INSERT() String Function
  17. MySQL INSTR() String Function
  18. MySQL LCASE() String Function
  19. MySQL LEFT() String Function
  20. MySQL LENGTH() String Function
  21. MySQL LIKE Operator
  22. MySQL LOAD_FILE() String Function
  23. MySQL LOCATE() String Function
  24. MySQL STRCMP() Function