Search In
By using INSERT INTO SELECT Statement one can copy data from one table to other existing table.
Syntax:
To copy all the columns from one table to another table:
INSERT INTO table_name1 (SELECT * from table_name);
To copy only the selected columns
To set a checkbox checked with a certain value we use a function prop() with the attribute selector.
$('selector').prop('checked', true);
For example:
<input class="chkbox" name="ex[]" type="checkbox" value="0">0
<input class="chkbox"
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
Hi Reader's,
Welcome to FindNerd, today we are going to discuss combining two strings together in PHP.
The PHP concatenate(.) is used for combining two string values and create one string.
you can see bellow example:
<?php
//firstly crea
UPPER(str)
UPPER() function returns the string str with all characters changed to uppercase according to the current character set mapping means if you want to get a string with all character in upper case then you can use this function.
Here is so
Hello Guys
In JQuery, Events trigger a JQuery function to an event handler for the selected elements in the Html page.
Currently we are using jQuery 1.7, So you should use jQuery.function.on() as below :
$(staticAncestors).on(eventName, dynamicCh
In openerp first install the resource module and inherit the object of resource.calendar and If no calendar is provided, just return the previous day and day of a resource.calendar. If calendar resource is no given simply remove one day from the subm
If you want to get all those values which exist in an array and also exist in other array means intersect values between an array and the set of other arrays then you can use a predefined php function array_intersect. array_intersect() returns an arr
Hello Friends,
If you want to compare two array with respect to keys not values then you can use a predefined PHP function "array_diff_key()". array_diff_key function compares the keys from array1 against the keys from array2 and returns the differe
In SQL we can create the primary key
Ex: create table student
(
stid int primary key identity(1,1),
stname varchar(50)
)
In SQL we can also create the foreign key using SQL query
Ex: create table account
(
staccid int primary ke
