How do I find out all databases starting with ‘test‘?

Options
- SHOW DATABASES LIKE ‘%test%’;
- SHOW DATABASES LIKE ‘%test;
- SHOW DATABASES LIKE ‘'test'%’;
- SHOW DATABASES LIKE ‘test%’;


CORRECT ANSWER : SHOW DATABASES LIKE ‘test%’;

Discussion Board
Reply:-

The answer will be 4.

rekha 07-8-2016 07:23 AM

not a error

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

gijina .r 07-4-2014 03:13 AM

error

3rd and 4th options are same

sagar 03-23-2014 02:20 PM

Write your comments

 
   
 
 

Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Advertisement