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.


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