{"id":21904,"date":"2016-06-10T05:01:13","date_gmt":"2016-06-10T05:01:13","guid":{"rendered":"https:\/\/www.testingdocs.com\/questions\/?p=21904"},"modified":"2024-12-16T14:25:59","modified_gmt":"2024-12-16T14:25:59","slug":"what-is-the-statement-to-list-the-available-mysql-databases","status":"publish","type":"post","link":"https:\/\/www.testingdocs.com\/questions\/what-is-the-statement-to-list-the-available-mysql-databases\/","title":{"rendered":"What is the statement to list the MySQL databases?"},"content":{"rendered":"

Q) What is the statement to list the available MySQL databases?<\/strong><\/p>\n

a) LIST DATABASES;<\/p>\n

b) SHOW DATABASES;<\/p>\n

c) SHOW DATABASES:<\/p>\n

d) SHOW DATABASES \\G<\/p>\n

Choose all the correct options.<\/p>\n

Explanation<\/h2>\n

Let’s understand why some options are incorrect and the then learn the correct options and reasons for them.<\/p>\n

Incorrect Options<\/h2>\n

Options a) and c) are NOT<\/strong> correct.<\/p>\n

LIST DATABASES; is not a valid MySQL statement. We get the following error when we issue the statement. Hence option a<\/strong> is NOT correct.<\/p>\n

mysql> LIST DATABASES;<\/em>
\nERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘LIST DATABASES’ at line 1<\/p>\n

The valid statement terminator is ; or \\G\u00a0 or \\g. Semi-colon is not the correct statement terminator and the mysql prompt doesn’t end with the semi-colon. Hence option c<\/strong> is NOT correct.<\/p>\n

Correct Answer<\/strong><\/h2>\n

The correct options are\u00a0 b) and d).<\/strong><\/p>\n

SHOW DATABASES; and SHOW DATABASES \\G are valid statements to list the available MySQL databases.<\/p>\n

SHOW DATABASES; statement displays the output in tabular format as shown below:<\/p>\n

mysql> SHOW DATABASES;<\/em>
\n+——————–+
\n| Database |
\n+——————–+
\n| information_schema |
\n| mysql |
\n| performance_schema |
\n| sakila |
\n| sys |
\n| world |
\n| worlddemo |
\n+——————–+
\n7 rows in set (0.00 sec)<\/p>\n

 <\/p>\n

\"LIST<\/p>\n

 <\/p>\n

SHOW DATABASES \\G statement displays the output as row format as shown below:<\/p>\n

mysql> SHOW DATABASES \\G
\n*************************** 1. row ***************************
\nDatabase: information_schema
\n*************************** 2. row ***************************
\nDatabase: mysql
\n*************************** 3. row ***************************
\nDatabase: performance_schema
\n*************************** 4. row ***************************
\nDatabase: sakila
\n*************************** 5. row ***************************
\nDatabase: sys
\n*************************** 6. row ***************************
\nDatabase: world
\n*************************** 7. row ***************************
\nDatabase: worlddemo
\n7 rows in set (0.00 sec)<\/p>\n

\"List<\/p>\n

Hence, b and d are correct options.<\/p>\n

—<\/p>\n

MySQL Tutorials<\/h2>\n

MySQL Tutorials on this website:<\/p>\n

https:\/\/www.testingdocs.com\/mysql-tutorials-for-beginners\/<\/a><\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

Q) What is the statement to list the available MySQL databases? a) LIST DATABASES; b) SHOW DATABASES; c) SHOW DATABASES: d) SHOW DATABASES \\G Choose all the correct options. Explanation Let’s understand why some options are incorrect and the then learn the correct options and reasons for them. Incorrect Options Options a) and c) are […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[520],"tags":[],"class_list":["post-21904","post","type-post","status-publish","format-standard","hentry","category-mysql-database","has-post-title","has-post-date","has-post-category","has-post-tag","has-post-comment","has-post-author",""],"_links":{"self":[{"href":"https:\/\/www.testingdocs.com\/questions\/wp-json\/wp\/v2\/posts\/21904","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.testingdocs.com\/questions\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.testingdocs.com\/questions\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.testingdocs.com\/questions\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.testingdocs.com\/questions\/wp-json\/wp\/v2\/comments?post=21904"}],"version-history":[{"count":20,"href":"https:\/\/www.testingdocs.com\/questions\/wp-json\/wp\/v2\/posts\/21904\/revisions"}],"predecessor-version":[{"id":26492,"href":"https:\/\/www.testingdocs.com\/questions\/wp-json\/wp\/v2\/posts\/21904\/revisions\/26492"}],"wp:attachment":[{"href":"https:\/\/www.testingdocs.com\/questions\/wp-json\/wp\/v2\/media?parent=21904"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.testingdocs.com\/questions\/wp-json\/wp\/v2\/categories?post=21904"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.testingdocs.com\/questions\/wp-json\/wp\/v2\/tags?post=21904"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}