MySQL Tutorial for Beginners - 11 - Interview Questions on MySQL Part-I
Hi Friends,
In this video, we are going to talk about Interview Questions on MySQL. I also provided answers for the questions discussed in the video in description.
Please subscribe this channel, so that you will not miss any videos in future:
/ @oceanofcode
Questions discussed on MySQL in this video:
==========================================
1. 00:44 Question: What is the query to return the number of records in "college2" table?
Answer: select count(*) from college2;
2. 01:54 Question: How many rows will be returned by below query:
select * from college2 where lect_salary between 57260 and 87000; //will return 6 rows
Answer: Query will return 6 rows.
3. 04:20 Question: What is the port used by MySQL client?
Answer: Port 3306 is the default port for the MySQL Protocol, which is used by the mysql client, MySQL Connectors, and utilities such as mysqldump and mysqlpump.
4. 04:44 Question: How to delete a record in which hometown value is Jodhpur?
Answer: delete from college2 where lect_hometown='Jodhpur';
5. 06:01 Question: What is the query to return different lect_hometown values from "college2" table?
Answer: select distinct(lect_hometown) from college2;
6. 07:19 Question: How to insert this record (lect_id = 17, lect_hometown = 'Hampi', lect_salary = 68600) in "college2" table?
Answer: insert into college2(lect_id, lect_hometown, lect_salary) values(17, 'Hampi', 68600);
==========================================
XAMPP Download link for All OSes:
https://www.apachefriends.org/downloa...
More Videos of this channel:
==========================================
What is VLOOKUP in Excel? in Simple words..
• What is VLOOKUP in Excel? in Simple w...
MySQL Tutorial for Beginners - 1 - Creating a Database and adding a Table in it
• MySQL Tutorial for Beginners - 1 - Cr...
MySQL Tutorial for Beginners - 2 - Inserting data into table
• MySQL Tutorial for Beginners - 2 - In...
MySQL Tutorial for Beginners - 3 - Select data from table and Update data of the table
• MySQL Tutorial for Beginners - 3 - Se...
MySQL Tutorial for Beginners - 4 - Deletion, Alteration, Renaming of Database and its Tables PART-I
• MySQL Tutorial for Beginners - 4 - De...
MySQL Tutorial for Beginners - 5 - Deletion, Alteration, Renaming of Database and its Tables PART-II
• MySQL Tutorial for Beginners - 5 - De...
MySQL Tutorial for Beginners - 6 - What is Foreign key and how to create it including IMP concepts
• MySQL Tutorial for Beginners - 6 - Wh...
MySQL Tutorial for Beginners - 7 - What is INNER JOIN? (on two tables and three tables)
• MySQL Tutorial for Beginners - 7 - Wh...
MySQL Tutorial for Beginners - 8 - What is LEFT OUTER JOIN? (Also called as LEFT JOIN)
• MySQL Tutorial for Beginners - 8 - Wh...
MySQL Tutorial for Beginners - 9 - What is RIGHT OUTER JOIN? (Also called as RIGHT JOIN)
• MySQL Tutorial for Beginners - 9 - Wh...
MySQL Tutorial for Beginners - 10 - What is FULL OUTER JOIN? (Also called as FULL JOIN)
• MySQL Tutorial for Beginners - 10 - W...
Learn 20 Basic but Important Commands Of Linux Terminal in just 20 minutes
• Learn 20 Basic but Important Commands...
How to write a Regular Expression for an Email-ID and a Mobile Number
• How to write a Regular Expression for...
How to write Regular Expression for IPv4 and IPv6 IP addresses
• How to write Regular Expression for I...
==========================================
Checkout my second channel on youtube for General Queries on WhatsApp etc. and its videos:
/ @aadityakavthekar
==========================================
How to Download WhatsApp Status?
• How to Download WhatsApp Status?
How to Disable WhatsApp Blue Ticks feature for Read Messages?
• How to Disable WhatsApp Blue Ticks fe...
How to Prevent People from adding YOU in their WhatsApp Groups without your Permission?
• How to Prevent People from adding YOU...
Learn How to Upload a video on YouTube within just 5 minutes
• Learn How to Upload a video on YouTub...
How to type in Marathi, Hindi, Telugu etc with English Keyboard in our Mobile?
• How to type in Marathi, Hindi, Telugu...
How to delete paytm account permanently in English?
• How to delete paytm account permanent...
==========================================
You can follow me on Quora:
https://www.quora.com/profile/Aaditya...
LinkedIn:
/ aaditya-kavthekar-03a64b48
Facebook Page Link for latest updates:
/ ocean-of-code-112216190150036
Twitter:
/ askavthekar
#SQL #MySql #MySQLQuestions #Interview questions on MySQL
