AND OR Operator in MySql

AND OR Operator in MySql

SUMMARY

In this video we will learn about and operator and or operator in mysql. Generally to filter data from any table we use where clause along with condition.

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.

WHAT IS AND OPERATOR AND OR OPERATOR

In case of and operator if both conditions are true which we have provided then we will get the output otherwise not.In case of or operator if one condition is true we will get the output.

EXAMPLE OF AND &OR OPERATOR

In the above video we have seen in first query our two conditions are true there fore we got the output ,it had fetched result from database. in the second query one condition is true and we use and operator so no row had fetched from database.

In the or operator condition if one condition is true we will get the output from database . In the above video or operator checks our two conditions one by one for the first condition we got the first row and for the second condition we got the next two rows.

CONCLUSION

In this video we have learned about and operator and or operator in mysql.

Visit Website : techrideradmin.blogspot.com