Search In
To send an e-mail with mixed content you requires to set Content-type header to multipart/mixed. Then, text and attachment sections can be specified within boundaries.
A boundary started with two hyphens followed by a unique number, which cannot appe
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 LIKE operator is used to search for a specified pattern for a column in a WHERE clause .
LIKE Syntax
SELECT column_name
FROM table_name
WHERE column_name LIKE pattern;
We have a table "employee" as below:
employee
id firs
In MySQL, the ORDER by keyword is used to get records from a table in sorted order. The ORDER BY keyword can use one or more columns to sort the result-set.
We can sort the records in both ascending and descending order.By default, ORDER by keyword
Hello Reader if you are making the content based website where you want to show div in bounce or blink effect. Here this code is driven by Jquery.
First create html file with name bounce.html and its code will go like this:-
<!DOCTYPE html>
Hello Readers,
jQuery data method is usually used to set and get data functionality.
Attach data to a HTML tag(like div or span) element, then retrieve the data.
The jQuery data() method attaches data to, or gets data from, selected elements.
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
Transactions are very important part of MySql and for handling the transactions the Transaction Control Language (TCL) is used. Transactions are basically used to handle all the changes made in the database.
Rolling back a transaction means storing t
Hi All,
You can add auto layout constraints by using Storyboard Interface OR by adding constraints dynamically. There are three ways to add constraint dynamically (as per Apple Inc.)
NSLayoutConstraint is one of the way is used to add autolayout co
1) Final:
Final is a keyword. It is used to store constant values in variable. The value can't be changed later on.
The class which is declared as final cannot be inherited.
The method which is declared as final cannot be overridden.
Example:
c
