Search In
String-valued functions return NULL, if the the result's length would be greater than the value of the max_allowed_packet system variable.
The first position of a string (for those functions which operate on string), is numbered 1.
Noninteger argum
String-valued functions return NULL, if the the result's length would be greater than the value of the max_allowed_packet system variable.
The first position of a string (for those functions which operate on string), is numbered 1.
Noninteger argum
For doing that we need to create procedure first and also define the repeating interval to call it again
We will create procedure named getnotification from the particular database that gets fired after 3:30 hours on a daily basis.
When we gets
CONCAT_WS(separator,str1,str2,...)
The full form of CONCAT_WS is concatenate with Separator which is a special form of CONCAT(). The first argument in CONCAT_WS is used as a separator for concatenate all other arguments. The separator is added betw
Hello Readers, If you want to implode the array keys from multi-dimensional array then now PHP 5.5 offers you much easier way to do this.
Lets see the example as below:-
Array
(
[0] => Array
(
[studenID] => 54874
Hello Reader's if you want to get the shortest way to get the max value of the given array, Then by using JS you do it fast.
To find the result you have to use Math.max() function.
Lets's see the working example as given below:-
<!DOCTYPE html&
QUOTE(str)
Quotes function used to produce a result that can be used as a properly escaped data value in an SQL statement of a string. The string is returned enclosed by single quotation marks and with each instance of backslash (“\”), single quote
This article explains the MySQL string functions which are used to concatenate two or more strings.
1. CONCAT : CONCAT() function is used to generate a string by concatenating two or more strings. The function take one or more strings as arguments
Hello Friends,
If you are looking to execute select query in codelgniter. Please review the code below:
// Pass the table attributes you need to fetch
$this->db->select('id, first_name, lastname');
OR
$this->db->select('*');
// Defi
There is method to add elements at the beginning of an array using unshift method
The array unshift method adds element at the beginning of an array and returns its new length. This method can be applied to the objects that resembles an array.
Syn
