Which of the following is NOT supported in MySQL?
(A). FETCH
(B). LIKE
(C). REVOKE
(D). JOIN
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