Similar Topics

Web Technologies

32.6k+ articles

2k+ articles

1.6k+ articles

1.2k+ articles

1.2k+ articles

310+ articles

310+ articles

20+ articles

SQLmysql

30+ posts

Popular articles

Recent articles

How to Select the First Row of Each GROUP BY in SQL?

Last updated: 28 January 2023

The GROUP BY Statement in SQL is used to arrange identical data into groups with the help of some functions. To select the first row of each group in SQL, you can use the ...read more

Technical Scripter

Technical Scripter 2022

MySQL | CAST( ) Function

Last updated: 12 May 2023

The MySQL CAST() function is used for converting a value from one datatype to another specific datatype. The CAST() function accepts two parameters which are the value to ...read more

MySQL | COALESCE( ) Function

Last updated: 21 November 2019

The MySQL COALESCE() function is used for returning the first non-null value in a list of expressions. If all the values in the list evaluate to NULL, then the COALESCE() ...read more

Similar Topics

Web Technologies

32.6k+ articles

2k+ articles

1.6k+ articles

1.2k+ articles

1.2k+ articles

310+ articles

310+ articles

20+ articles

MySQL | IF( ) Function

Last updated: 21 November 2019

The MySQL IF() function is used for validating a condition. The IF() function returns a value if the condition is TRUE and another value if the condition is FALSE. The MyS ...read more

MySQL | CONVERT( ) Function

Last updated: 19 November 2019

The MySQL CONVERT() function is used for converting a value from one datatype to a different datatype. The MySQL CONVERT() function is also used for converting a value fro ...read more

MySQL | ISNULL( ) Function

Last updated: 19 November 2019

The MySQL ISNULL() function is used for checking whether an expression is NULL or not. This function returns 1 if the expression passed is NULL, else it returns 0.The ISNU ...read more

MySQL | SHA1( ) Function

Last updated: 17 February 2021

The MySQL SHA1() function is used for encrypting a string using the SHA-1 technique. The SHA1 stands for secure hash algorithm and it produces a 160-bit checksum for a use ...read more

MySQL | ENCODE( ) Function

Last updated: 13 November 2019

The MySQL ENCODE() function is used for encoding a plain text string. The MySQL ENCODE() function returns a binary string which of the same size of the plain text string. ...read more

MySQL | DECODE( ) Function

Last updated: 13 November 2019

The MySQL DECODE() function is used for decoding an encoded string and return the original string. The MySQL DECODE() function returns empty strings if the encoded string ...read more

MySQL | PASSWORD Function

Last updated: 08 November 2019

The MySQL PASSWORD function is used for the generation of a hashed password using a plain-text password string It uses hashing techniques to generate the hashed password. ...read more

MySQL | MD5 Function

Last updated: 08 November 2019

The MySQL MD5 function is used to return an MD5 128-bit checksum representation of a string. The MD5 message-digest algorithm is a widely used hash function producing a 12 ...read more

MySQL | AES_DECRYPT ( ) Function

Last updated: 14 September 2021

The MySQL AES_DECRYPT function returns the original string after decrypting an encrypted string. It uses AES(Advanced Encryption Standard) algorithm to perform the decrypt ...read more

MySQL | AES_ENCRYPT ( ) Function

Last updated: 25 August 2021

The MySQL AES_ENCRYPT function is used for encrypting a string using Advanced Encryption Standard (AES) algorithm. The MySQL AES_ENCRYPT function encodes the data with 128 ...read more

MySQL | Common MySQL Queries

Last updated: 14 August 2021

MySQL server is a open-source relational database management system which is a major support for web based applications. Databases and related tables are the main componen...read more

Difference between MySQL and MS SQL Server

Last updated: 30 January 2019

SQL is an acronym for Structured Query Language. It is used to access, manipulate and retrieve information from a database. MySQL is an open source Relational Database Man ...read more