Sunday, August 30, 2020
Thursday, June 18, 2015
Wordpress- versatile Content Management System (CMS)
Hey beginners, if you are confused on choosing plateform to develop you website. Then don't be. I will tell you, why you should choose Wordpress to develop your websites.
Wordpress is a very versatile Content Management System (CMS) which was evolved with the concept of blogging platform. Now Wordpress is more than ten years old and in these time, it has evolved through fully functional websites, mobile applications and ecommerce. While you can still use WordPress to create a simple blog, no doubt on it.
Wordpress is a very versatile Content Management System (CMS) which was evolved with the concept of blogging platform. Now Wordpress is more than ten years old and in these time, it has evolved through fully functional websites, mobile applications and ecommerce. While you can still use WordPress to create a simple blog, no doubt on it.
Saturday, July 19, 2014
Join in MySQL
Join clause is used to combine rows from two or more tables depending upon common field between them.
There are different kinds of Joins.
The most common and useful Join is Inner Join.
Inner Join:
It will return all rows from multiple tables where the condition is met.
There are different kinds of Joins.
The most common and useful Join is Inner Join.
Inner Join:
It will return all rows from multiple tables where the condition is met.
Thursday, July 17, 2014
Aggregate Functions in MySQL
Aggregate Functions are those functions which are used in SQL. They return a single value which is calculated from values in the columns from a particular table.
The aggregate functions are below:
AVG()- It returns a average value
COUNT() - It returns the number of rows in a table
MAX() - It returns the maximum value stored in a table
MIN() - It returns the minimum value stored in a table
SUM() - It returns the sum of all the values of specified column
The aggregate functions are below:
AVG()- It returns a average value
COUNT() - It returns the number of rows in a table
MAX() - It returns the maximum value stored in a table
MIN() - It returns the minimum value stored in a table
SUM() - It returns the sum of all the values of specified column
Wednesday, July 16, 2014
Cursors
What are Cursors?
A cursor is a temporary work area created in the system memory when a SQL statement is executed. A cursor contains information on a select statement and the rows of data accessed by it. This temporary work area is used to store the data retrieved from the database, and manipulate this data. A cursor can hold more than one row, but can process only one row at a time. The set of rows the cursor holds is called the active set.
There are two types of cursors in PL/SQL:
Implicit cursors:
These are created by default when DML statements like, INSERT, UPDATE, and DELETE statements are executed. They are also created when a SELECT statement that returns just one row is executed.
A cursor is a temporary work area created in the system memory when a SQL statement is executed. A cursor contains information on a select statement and the rows of data accessed by it. This temporary work area is used to store the data retrieved from the database, and manipulate this data. A cursor can hold more than one row, but can process only one row at a time. The set of rows the cursor holds is called the active set.
There are two types of cursors in PL/SQL:
Implicit cursors:
These are created by default when DML statements like, INSERT, UPDATE, and DELETE statements are executed. They are also created when a SELECT statement that returns just one row is executed.
Between and In Operators in SQL
Between Operator
It is used to select values within a range.
It is used to select values within a range.
Tuesday, July 15, 2014
SubQuery in MySQL
A subquery is a query inside another query or it is a nested query which is embedded within the WHERE clause.
Subqueries can be used with the SELECT, INSERT, UPDATE, and DELETE statements along with the operators like =, <, >, >=, <=, IN, BETWEEN etc.
Subqueries can be used with the SELECT, INSERT, UPDATE, and DELETE statements along with the operators like =, <, >, >=, <=, IN, BETWEEN etc.
Subscribe to:
Posts (Atom)