MySQL: Show databases and show tables

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 >>