Search In
JavaScript encodeURIComponent() function : The encodeURIComponent() function is used to encode the URL. It encodes the all special character including characters : , / ? : @ & = + $ #
Syntax of encodeURIComponent() function :
encodeURICompone
JavaScript decodeURIComponent() function : The decodeURIComponent() function is used to decode the encoded URL components.
Syntax of decodeURIComponent() function :
decodeURI(uri)
uri : Required. This is the encoded URL which need to encode.
This tutorial explains how to use limit clause within MySQL query to fetch records. The MySQL LIMIT clause is used to limit the number of records returned from MySQL query by using value passed with LIMIT clause. Limit clause is used with the SELECT
We can insert data from one table to another in MySQL. For this we use the INSERT INTO SELECT statement that selects the data from on table and inserts that data into another table.
INSERT INTO SELECT Syntax
We can select and insert all the columns
When we don't define any data for a column then the column holds the NULL value. In MySQL, NULL values are used to represent data that is missing.
NULL Values
If you have created a table with optional columns then you can insert and update records
The HAVING clause is used with aggregate functions as the WHERE clause can not be used with them.
HAVING Syntax
SELECT column_name, aggregate_function(column_name)
FROM table_name
WHERE column_name operator value
GROUP BY column_name
HAVING aggrega
In MySQL, the UPDATE statement is used to update existing records in a table.
UPDATE Syntax
UPDATE table_name
SET column1=value1,column2=value2,...
WHERE some_column=some_value;
In the above syntax, WHERE clause specifies which row or rows will b
CTE
CTE stands for Common Table expressions. It was introduced with SQL Server 2005. It is a temporary result set and typically it may be a result of complex sub-query.CTE improves readability and ease in maintenance of complex queries and sub-que
Temp Table -Temporary Temp Tables
1)They can be created at run time in Tempdb database.
2)DDL,DML statements like select,update which can be executed on regular tables can be done on temporary tables. They can have constraints and can be indexed.
Hello Reader's if you need to get all the files that exists inside any directory then you can get it by using codeigntier FTP class library. This is quick and very easy to get result.
For example if you have amazon S3 bucket and you wish to get all
