• Skip to main content
  • Skip to primary sidebar

Founder at work

Master the skills to create and launch your next SaaS company

  • About Me
  • Reviews
  • Resources
  • Community
  • Contact
  • Lessons
  • Series
  • Search
  • Login

How to show databases in MySQL?

April 7, 2013 by Rick Hernandez Leave a Comment

show databases will show you the available databases which are available to be used.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| ricardohDB         |
| test               |
+--------------------+
3 rows in set (0.00 sec)

In my example i have three databases that are available to be selected from. Why would you want to select a database in the first Place? well databases hold inside of them something called tables! and MySQL can hold multiple databases which means you can have multiple tables Awesome Right?

Rick Hernandez

I always had a passion for the field of STEM (Science, Technology, Engineering, and Math) and I knew I wanted to do something to make a difference in the world. I just didn’t know where to start. I was an immigrant in a new country, grew up in a tough environment, and wasn’t sure how… Read More

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)

Related

Filed Under: MySQL, Programming

Primary Sidebar

Learn How To Take Your Idea And Convert It Into An App From Scratch Even If You Have Never Written A Single Line Of Code.

  • How to Find Your Next Great App Idea
  • The Secret To Getting PAID To Build Your Own App
  • How To Create Your App (SaaS, Mobile, VR, AR, Game)
  • How To Monetize Your Apps
Learn More
4.82 Ratings

Copyright © 2025 · JSecademy Blog Theme on Genesis Framework · WordPress · Log in