Purge Binary log
If you have enabled binary logging for the point-in-time recovery (or using replication in your environment) option and forgot to
Read more
MySQL
MySQL trim function
MySQL TRIM() function returns a string after removing all prefixes or suffixes from the given string. Syntax TRIM([{BOTH | LEADING
Read more
PHP – MySQL : Create Database
[root@mysqlDB]# mysqladmin -u root -p create eduguru Enter password:****** This will create a MySQL database eduguru. This is a simple example
Read more MySQL RAND Function
MySQL has a RAND function that can be invoked to produce random numbers between 0 and 1: mysql> SELECT RAND(
Read more mysql locate function
MySQL LOCATE() returns the position of the first occurrence of a string within a string. Both of these strings are
Read more mysql limit clause
What is MySQL limit clause? The LIMIT clause is used in the SELECT statement to constrain the number of rows
Read more mysql length function
Description: MySQL LENGTH() returns the length of a given string. Syntax: LENGTH (str) Argument: Name Description str
Read more mysql concat function
MySQL CONCAT function is used to concatenate two strings to form a single string. Description: MySQL CONCAT() function is used
Read more MySQL substring function
MySQL SUBSTRING() returns a specified number of characters from a particular position of a given string. Syntax: SUBSTRING(str, pos, len)
Read more mysql if function
Syntax: IF(expr,if_true_expr,if_false_expr) MySQL IF function is control flow functions that returns a value based on a condition. The IF function
Read more