Featured Tutorials:Java Programming for Beginners, YouTube API, SQL Injection, JavaScript quiz, SQL quiz, PHP quiz, Python quiz, JavaScript Advanced quiz

MySQL FUNCTIONS and OPERATORS

has average rating 6 out of 10. Total 1 users rated.

<<PreviousNext>>

Description

In the following section we have given a list of FUNCTIONS and OPERATORS in MySQL as any one can view the FUNCTIONS at a glance and jump immediately to his/her requirement.

MySQL Function & Operators	Description
Introduction of Mysql functions and operators	Types of MySQL functions and operators.
Mysql Comparison Functions and Operators	Some Comparison Functions and Operators are - Between and COALESCE() NULL Safe equal to operator (<=>) Equal operator(=) Greater than or equal operator(>=) Greater than operator(>) GREATEST() IN() INTERVAL() IS NOT NULL IS NOT IS NULL IS IS NULL() LEAST() LESS THAN OR EQUAL OPERATOR(<=) LESS THAN OPERATOR(<) LIKE NOT BETWEEN AND NOT EQUAL OPERATOR(<>,!=) NOT IN() NOT LIKE STRCMP()
Mysql Logical Operators	MySQL logical AND operator compares two expressions and returns true if both of the expressions are true. Some Logical Operators are - And operator Not operator Or operator Xor operator
Mysql Control Flow Functions	Some Control Flow Functions are - Case operator IF() IFNULL() NULLIF()
Mysql String Functions	Some String Functions in MySQL are - ASCII BIN BIT_LENGTH CHAR_LENGTH CHAR CHARACTER_LENGTH CONCAT_WS CONCAT ELT EXPORT_SET FIELD FIND_IN_SET FORMAT HEX INSERT INSTR LCASE LEFT LENGTH LIKE LOAD_FILE LOCATE LOWER LPAD LTRIM MAKE_SET MID NOT LIKE NOT REGEXP OCTET_LENGTH ORD POSITION QUOTE REGEXP REPEAT REPLACE REVERSE RIGHT RLIKE NOT RLIKE RPAD RTRIM SOUNDEX SOUNDS_LIKE SPACE STRCMP SUBSTR SUBSTRING_INDEX SUBSTRING TRIM UCASE UNHEX UPPER
Mysql Mathematical Functions	Some Mathematical Functions in MySQL are - ABS() ACOS() ASIN() ATAN2() ATAN() CEIL() CEILING() CONV() COS() COT() CRC32() DEGREES() DIV DIVISION EXP() FLOOR() LN() LOG() LOG2() LOG10() MOD() OCT() PI() POW() POWER() RADIANS() RAND() ROUND() SIGN() SIN() SQRT() TAN() TRUNCATE() FORMAT()
Mysql Date and Time Functions	MySQL Date and Time Functions are used in various type of date and time operation.
Mysql Encryption and Compression Functions	MySQL Encryption and Compression Functions are used to encrypt and decrypt a string. Some Encryption and Compression Functions in MySQL are - AES_DECRYPT() AES_ENCRYPT() COMPRESS() DECODE() DES_DECRYPT() DES_ENCRYPT() ENCODE() ENCRYPT() MD5() OLD_PASSWORD() PASSWORD() SHA1() UNCOMPRESS() UNCOMPRESSED_LENGTH()
Mysql Bit Functions	Some Bit Functions in MySQL are - BIT_COUNT BITWISE AND INVERT BITS BITWISE OR BITWISE XOR Left shift Right shift

photo credit: jerryfi_99 Photo is used under creative Common License.

<<PreviousNext>>

Rate this tutorial

Your Rating: not set

Share this tutorial

Continue reading

Mysql Comparison Functions and Operators

Mysql Logical Operators

Mysql Control Flow Functions

Mysql String Functions

Mysql Mathematical Functions

Looking for some other tutorial?

Recent Updates

Working with Ajax, PHP and MySQL

Create Responsive Image and Content Slider with Orbit

Python 3.2 Tutorial

Responsive Web Design with Twitter Bootstrap