Introduction to Database

1. Database : A collection of data in an organized manner. Data is a piece of information such as text,videos,audios ,numeric, dates,document files etc.Database is a structured system to put your data, ...
Read More

Installation of MySQL,creating database and table.

As we know we store data in database. There are many database .Among them MYSQL, Microsoft Database, Oracle, DB2, etc. are popular and are mostly used by everyone.  MySQL is ...
Read More

Querying data using SELECT and DISTINCT :

Select Clause and overview of clauses: The table consists of rows and columns. Row is called tuple or the instance of table(or entity) and Column is called attribute of table ...
Read More

WHERE clause:

Where clause is used to extract rows from the table based on particular expression or condition. Example: Whenever you write the statement in the database console. At first, program will start from ...
Read More

AND/OR operator:

AND/OR operator is used to combine Boolean expression for filtering data. These operator is used in WHERE clause. 1. AND operator : It is a logical operator that combines two or more Boolean ...
Read More

IN/BETWEEN operator:

1. IN operator: IN operator determine if a specified value matches any one of the list or a sub query. IN operator return 1 if the value of column or the expression ...
Read More

LIKE operator:

It is used to select the data from table based on specific pattern.It is used in WHERE clause of SELECT statement. There are two wild card used in LIKE operator i.e.% ...
Read More

LIMIT clause:

  • LIMIT clause:
This clause is used in SELECT statement to constraint the numbers of rows in the result. . Syntax: SELECT col1, col2, ……. FROM table LIMIT offset, count; Where, offset specifies first row to ...
Read More

SORTING DATA

  1. ORDER BY
The ORDER BY clause allows to, Sort a result set by a single column or multiple columns. Sort a result set by different columns in ascending or descending order.By default, ...
Read More

MySQL alias:

  1. MySQL column alias
The  column names sometimes become  more technical making  the query difficult to understand. For this reason we use column alias. A simple syntax of  column alias is given ...
Read More

MySQL INNER JOIN:

MySQL INNER JOIN clause matches rows in one table to rows in other table and allows us to query rows that contains columns from both table. A syntax of MySQL INNER ...
Read More

MySQL Left &Right Join

  1. MySQL LEFT JOIN
When we join a table t1 with table t2 using left join , if a row from left table matches row from right table based on join ...
Read More

MySQL self join

A self join is special case of join statement where we join a table to itself. In self join , we must use table alias to identify left table and ...
Read More

MySQL Subquery

MySQL subquery is simply using a query within another query. In MySQL subquery we nest a query (inner query) within another query (outer query) and use the result of the inner ...
Read More

Introducing to MySQL GROUP BY clause

The GROUP BY clause,groups a set of rows into a set of summary rows by values of columns or expressions. The GROUP BY clause returns one row for each group.We ...
Read More

MySQL UNION and INTERSECTION operator

  1. MySQL UNION Operator:
MySQL UNION operator allow to combine two or more result sets from multiple tables into a single result set.   . Syntax: Select  column1, column2 Union [Distinct | all] Select column1, column2 Union ...
Read More

Copyright © 2016 InfoxIT Portal. All rights reserved.
Seo wordpress plugin by www.seowizard.org.
Scroll To Top
Visit Us On FacebookVisit Us On Google PlusVisit Us On YoutubeCheck Our Feed