Select Commands | MySQL Syntax | Like | IS | IN | DISTINCT | BETWEEN | WHERE | ORDER BY | GROUP BY

Hello everyone, Welcome back to my channel IP Ki Paathshala This video will cover all the basic concepts of MySQL syntaxes based upon Class XII CBSE curriculum You can also learn from this video What are the keywords used in SELECT Commands? What is the use of the LIKE keyword? What is the use of the IS keyword? What is the use of the IN keyword? What is the use of the BETWEEN keyword? What is the use of the DISTINCT keyword? What is the use of the WHERE clause in Select Command? What is the use of the ORDER BY clause in Select Command? What is the use of the GROUP BY clause in Select Command? Which are the keywords used in Alter Table Commands? Write syntax to add Primary Key in a table? Write syntax to add Foreign Key in a table? What is a Cross Join? What is an Equi-Join? What is Natural Join? What is a Left Join? What is a Right Join? Write the use of On and Using Keyword? What is a DDL command? What are the different types of commands in DDL? What is a database? Write syntaxes of creating and dropping a database? Write the syntax to open or to use a database? How we can create a table in MySQL? I hope you like it guys Please do like, subscribe and share this video. Post your queries in comments. Thank you Shashank Jain Contact – 8619533963