Which of the following is not available in MySQL?

Which of the following is NOT supported in MySQL?
(A). FETCH
(B). LIKE
(C). REVOKE
(D). JOIN
MCQ Answer:(A). FETCH

Example of LIKE Query in MySQL

It will show all teacher’s names starting with t

SELECT * FROM Teachers
WHERE TeacherName LIKE 't%';

Example of REVOKE Query in MySQL

To revoke all privileges from a user, we can write the following REVOKE ALL query:

REVOKE 
    ALL [PRIVILEGES], 
    GRANT OPTION 
FROM user1 [, user2];

Example of JOIN Query in MySQL

joins PHP MySQLi

Applying join on two tables

left Join PHP MySQLi

Example of Inner Join Query

select * from t4tutorials_finance inner join user_details on user_details.userid=T4Tutorials_finance.t4tutorials_id

Example of Left join Query in MySQL

select * from t4tutorials_finance left join user_details on user_details.userid=T4Tutorials_finance.t4tutorials_id

Example of Right join Query in MySQL

select * from t4tutorials_finance right join user_details on user_details.userid=T4Tutorials_finance.t4tutorials_id

Highly Recommended  Important MCQs with Explanation

Computer Science MCQs (Homepage)

Prof.Fazal Rehman Shamil (Available for Professional Discussions)
1. Message on Facebook page for discussions,
2. Video lectures on Youtube
3. Email is only for Advertisement/business enquiries.