mysql select database

1SHOW TABLES from <databasename>;

1SELECT column_name(s) FROM table_name

1CREATE DATABASE [IF NOT EXISTS] database_name
2[CHARACTER SET charset_name]
3[COLLATE collation_name]
4

1        
2         USE database_name;
3Code language: SQL (Structured Query Language) (sql)

1select * from table_name

1//SELECT Database is used in MySQL to select a particular database to work with. This query is used when multiple databases are available with MySQL Server.
2
3//You can use SQL command USE to select a particular database.
4
5Syntax:
6USE database_name;
7
8//suppose database name is employee
9
10use employee;