MySQL: Show databases and show tables

This entry is part 14 of 26 in the series Learn MySQL

Once you have login to mysql, you can use the help command to display a list of mysql commands.

Notice this line that all commands must end with ; in the screenshot.

sqlcommands

So to show the databases we are currently having, we can use

show databases;

showdatabases

And to display the tables in the databases,

use allartist;
show tables;

showtables

 

Series Navigation<< MySQL: Giving column as alias name
MySQL: Using user defined variable >>