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.


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

show databases;


And to display the tables in the databases,

use allartist;
show tables;



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