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
|
1 2 |
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:
|
1 2 3 4 |
REVOKE ALL [PRIVILEGES], GRANT OPTION FROM user1 [, user2]; |
Example of JOIN Query in MySQL
Applying join on two tables
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