Data Types in MySQL

MySQL Data Types

A data type specifies the type of data to be stored, the possible values, the type of operations that can be performed and the … Read More

CREATE TABLE in MySQL

CREATE TABLE
In MySQL, the MySQL CREATE TABLE statement is used to create a new table in a database.

Syntax 1: To create a Table in MySQL. Read More

CREATE DATABASE in MySQL

CREATE DATABASE
To create a MySQL database, open the MySQL Command Line Client. The MySQL Command Line Client will appear with a mysqlprompt. Write the already … Read More

UNHEX() FUNCTION in MySQL

UNHEX() FUNCTION
The MySQL UNHEX function is used to convert a hexadecimal value to a string.

Syntax:

UNHEX (value);

Parameters:
value: It is used to specify the … Read More

SOUNDEX() FUNCTION in MySQL

SOUNDEX() FUNCTION
The MySQL SOUNDEX function is used to get a Soundex string.

Syntax:

SOUNDEX (string);

Parameters:
string: It is used to specify the string to evaluate.… Read More

QUOTE() FUNCTION in MySQL

QUOTE() FUNCTION
The MySQL QUOTE function is used to get the string which is passed in single quote.

Syntax:

QUOTE (string);

Parameters:
string: It is used to … Read More

ORD() FUNCTION in MySQL

ORD() FUNCTION
The MySQL ORD function is used to get the code for the specified string.

Syntax:

ORD (string);

Parameters:
string: It is used to specify the … Read More

OCT() FUNCTION in MySQL

OCT() FUNCTION
The MySQL OCT function is used to get the octal value of the specified number.

Syntax:

OCT (number);

Parameters:
number: It is used to specify … Read More

OCTET_LENGTH() FUNCTION in MySQL

OCTET_LENGTH() FUNCTION
The MySQL OCTET_LENGTH function is used to get the length of the specified string.

Syntax:

OCTET_LENGTH (string);

Parameters:
string: It is used to specify the … Read More

MAKE_SET() FUNCTION in MySQL

MAKE_SET() FUNCTION
The MySQL MAKE_SET function is used to get values from set for the given bit.

Syntax:

MAKE_SET (bits, string_1, string_2, … string_n );

Parameters:
bits:Read More