• MySql
  • HTML/CSS
  • JavaScript
  • Jquery
  • PHP
  • MySql
  • OOPS
  • Smarty
  • Command
• Menu
Basic
Data Types
Query Syntax
Variables
Control Flow Functions
Indexing
MySQL Functions
• Math
• Aggregate
• String
• Comparison
• Date
• Joins
MySQL Constraints
Some Special Features

Math Function

SELECT ABS(2); // 2;
SELECT ABS(-32); //32
        

SELECT CEIL(1.23); // 2
SELECT CEILING(-1.23); // -1
    

SELECT FLOOR(1.23); //1
SELECT FLOOR(-1.23); // -2
    

SELECT MOD(29, 9); // 2
SELECT 29 % 9; // 2
SELECT 29 MOD 9; // 2
    

SELECT MOD(34.5,3); // 1.5
MOD(N,0) returns NULL.