IN and NOT IN operator in MySql

IN and NOT IN operator in MySql

SUMMARY 

In this video we will learn about in operator and not in 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.

DEFINATION OF IN AND NOT IN OPERATOR

In case of in operator we will get those rows which we provide within the in values. In case of not in operator we will get those rows which is not provided within the not in operator.

EXAMPLE FOR IN AND NOT IN OPERATOR

In the above video we have fetched the records which department nos are 1,3 and 5 using in operator. We have also fetched the records which dept nos are not 1,3 and 5 using not in operator.

CONCLUSION

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

Thanks for reading .Visit Website for more details: techrideradmin.blogspot.com