Introduction of SQL

September 20th,2014     No Comments          

SQL is a standard query language is used to perform database action. SQL is a ANSI standard language. In this topic we will learn what is SQL and why we need it.

Read More

SELECT Query

September 21st,2014     No Comments          

The SELECT statement or Query in SQL is use to select data from the database. You can select all data and also you can select specified data from SELECT query. In this topic we will learn how to select specified data and how to select all data by SELECT query.

Read More

WHERE Cluase in SELECT

September 22nd,2014     No Comments          

In SELECT statement we can also fetch the data from database depends on condition. To fetch data as per condition you have to use “WHERE” clause in the SELECT Statement.

Read More

DISTINCT Statement in SELECT

September 23rd,2014     No Comments          

The DISTINCT statement in Select is use to select only different values from table that means if there are some values are common than it will return only different values.

Read More

Like Condition in SELECT

September 24th,2014     No Comments          

The Like Statement in SQL or MySQL is used to fetch the data like some condition. In this topic we learn the patterns of Like condition and also how to use it in our Query.

Read More

INSERT INTO Statement

September 25th,2014     No Comments          

To insert data into database in MySQL we have INSERT INTO statement. You can also insert specified data in a column or in a row. In this topic we will learn how to insert data in database using INSERT INTO query.

Read More

UPDATE Statement

September 28th,2014     2 Comments          

To modify the data in database we have UPDATE statement. You can perform multiple modification with the help of Update statement.

Read More

DELETE Statement

September 29th,2014     No Comments          

To delete data from database in SQL we have DELETE statement. In this topic we will learn how to delete all data and how to delete specified data form database.

Read More

JOINs in SQL

January 2nd,2015     No Comments          

JOINS are used in SQL to join two tables and fetch the data from those joined tables. In SQL there are four types of Joins: Inner Join, Left Join, Right Join, and Full Join.

Read More

Inner Join in SQL

January 3rd,2015     No Comments          

The Inner Join is used when you want to fetch the all results from tables. It will return all data from table which is stored in Database.

Read More

Left Join in SQL

January 3rd,2015     No Comments          

The Left Join in SQL is use to fetch all data from the right table and the common data from the left table. In this topic we will learn about it.

Read More

Right Join in SQL

January 3rd,2015     No Comments          

The right join is use to fetch all data from the right table and if it is not matches to the left table also.

Read More

Introduction of MySQL

January 6th,2015     No Comments          

In PHP we are using MySQL Database. Because we are using XAMPP so MySQL is already installed in it we just have to start XAMMP and than start MySQL.

Read More

Connect MySQL with PHP

January 6th,2015     No Comments          

To use MySQL with PHP we have to connect it. To connect database we have to pass three parameters server name, user name and password. In this topic we will learn how to connect MySQL DB with PHP.

Read More

Select Database in PHP

January 8th,2015     No Comments          

After creating a database in phpmyadmin we have to select it in our PHP file. To select a database in PHP we have to write the proper syntax for that. In this topic we tell you how to select a created database.

Read More

Insert Data Into Table through PHP

January 8th,2015     No Comments          

You already created a database in phpMyAdmin and now create a table in that database. After creating a table we can insert data into that with the help of insert query through PHP.

Read More

Select Data From Database in PHP

January 9th,2015     No Comments          

After inserting data into table in database now we can select that data and display that data in a web page with the help of Select query. In this topic we will learn about it.

Read More

Update Data into Database in PHP

January 9th,2015     No Comments          

We can also modify the data that is inserted in the table in database. To update data in MySQL we have UPDATE query. This topic will explain you how to update or modify data into table.

Read More

Delete Data From Database in PHP

January 9th,2015     No Comments          

In this tutorial we will learn how to delete data from database through MySQL Query in PHP.

Read More