You are not logged in.

#1 2015-05-23 08:41:43

hasnain
Administrator
From: Chichawatni
Registered: 2014-10-13
Posts: 8,355
Website

Databases:

Question:
How do I find out all databases starting with test to which I have access to?

Option A):
SHOW DATABASES LIKE %test;
Option B):
SHOW DATABASES LIKE 'test'%;
Option C):
SHOW DATABASES LIKE test%;
Option D):
SHOW DATABASES LIKE %test%;

Correct Answer is Option C):
SHOW DATABASES LIKE test%;

Explanation:
3rd and 4th answer are not same
3rd answer : SHOW DATABASES LIKE " test% ';
4th answer : SHOW DATABASES LIKE ' test% ';
see the difference between the quotes


Failure is the first step towards seccess.

2015-05-23 08:41:43

Advertisement
Ads By Google

Re: Databases:



\n

Board footer