Search In
JavaScript Array shift() method : The shift() method is used to remove the first element of the array. The shift() method will return the first element which will be removed. The shift() method will change the length of the array.
Syntax of the shif
Sometimes we need to drop a column that we don't need further from the table. We can do this by using DROP keyword with ALTER command.
Syntax:
To drop/delete the column from a table, use the following syntax:
ALTER TABLE table_name
DROP COLUMN col
Sometimes we need to add a column that we require into the table. We can do this by using ADD keyword with ALTER command.
Syntax:
To add a column into a table, use the following syntax:
ALTER TABLE table_name
ADD COLUMN column_name datatype;
Exa
Auto-increment is used to allow a unique number when a new record inserted into a table. Generally we use Auto-increment to create value for primary key field automatically when a new record is inserted into a table.
Syntax:
The below statement cr
We need to upgrade our magento setup time to time with release of the editions because of security reasons. Sometime we need to apply the security patches also to resolve security issues. Here I am explaining how to apply securtiy patches without ssh
MAKE_SET(bits,str1,str2,...)
MAKE_SET function returns a set of values which are from string containing substrings separated by “,” characters, consisting of the strings that have the corresponding bit in bits set. str1 corresponds to bit 0, str2 to
Hello Readers If you want to hit the MySql queries from another page by your current page, The by using Angular js you can do this. Also angular js will offers you to show your records in a pre formated desing.
Let's see the example as below:-
&l
Hello Reader's if you need to cast the objects in PHP then this blog is helpful to you .
Here below I created a function which will cast the object and relocate the object to location as you define
function cast($destination, $sourceObject)
{
In MySQL, to handle a result set inside a procedure we use cursors. Cursors are:
Read only
Non-scrollable
Asensitive
Cursors can be used in stored procedure, stored functions and triggers.
Syntax:
Declare cursor:
Declare cursor_name cursor f
Hello User if want to show user's lat and long to screen then you can use the code as below:-
First you have to create a html page and named it file.html and paste the following code in it.
<!DOCTYPE html>
<html>
<body>
<p>
