Comparison operator in MySql





SUMMARY

In this video we will learn about Comparison operator in MySql.

DEFINITION OF COMPARISON OPERATOR

There are many comparison operator like equal,not equal ,greater than,less than etc.Suppose we need to find our salary from the database table ,need to find our some records for comparison purpose for that we can use this comparison operator.

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 department table. Now fetch all records form the table.

EXAMPLE OF COMPARISON OPERATOR


In our case there will be four queries. These are given below.

1) Now we want to fetch records whose salary is equal to 25000.

2) Now we want to fetch records whose salary is not equal to 25000.

3) Now we want to fetch records whose salary is greater than to 25000.

4) Now we want to fetch records whose salary is less to 25000.


SIGN OF COMPARISON OPERATOR


operator Sign
Equal operator ==
Not Equal Operator <>
Greater Than >

Less Than <


CONCLUSION

In this video we have learned about comparison operator in mysql.
To know more details follow my Website : techrideradmin.blogspot.com.