Show databases mysql docker

First, go inside docker container, run below command
docker exec -it mysql_container_name mysql -uroot -p
where “root” is the username for MySQL database. After running above command it will ask you a password.

Then Select Database, run below command
USE Name-Of-The-Database

get the list of all tables.
show tables;

Source: stackoverflow.com

Similar codes

0 vote207 views1 answer
Sql new line output
SQL
1 vote186 views1 answer
Round function in sql oracle
SQL
0 vote186 views1 answer
Sql roll up rows into columns
SQL
5 votes264 views1 answer
FSADeprecationWarning: SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and will be disabled by default in the future. Set it to True or False to suppress this warning.
SQL
3 votes277 views2 answers
How to modify rows in SQL Server
SQL
16 votes249 views6 answers
Insert sql
SQL
7 votes196 views3 answers
Python and mysql connectivity
SQL
0 vote223 views1 answer
Wordpress make wp user in db
SQL
1 vote192 views1 answer
Multiple count in sql
SQL
0 vote196 views2 answers
Coursera spark sql max count
SQL