Select Statement In MySql




SUMMARY 


In this tutorial we will learn about select statement in mysql.


PURPOSE OF SELECT STATEMENT

Normally select statement fetches all records from the table.if we need to retrieve some records from the database we can use select query to fetch our required records from the desired table within our database.

PREREQUISITE

In the above video first we login our mysql server . Then check all database list and select our preferred database.you select your database as per your requirement. In our case we select techrideradmin database . Then select the table list within the database. In our case we select dept table.

SYNTAX OF SELECT STATEMENT

We have one table that is department.Now we want to retrieve all records from this table so that we can use select * from table name; Also we can retrieve particular column from the table by specifying the column name like this.
select column 1,column 2 from table name

EXAMPLE OF SELECT STATEMENT

In mysql case we have dept table in the techrideradmin database. Now we want to fetch all records from the table of my database so we execute below command.

select * from dept;

Also we can retrieve selected column from the table use my desired column name .please see this video to know more.

CONCLUSION

In this tutorial we have learned about select statement in mysql.


Thanks for watching.Visit Website : techrideradmin.blogspot.com