ERROR 1046 (3D000): No database selected

Error Blog 

Hi Guys ,

This blog is about the error   ERROR 1046 (3D000): No database selected

Problem Statement

unable to query in mysql usiing command line client 

Error Details 

error Log

ERROR DETAILS 

mysql> select * from all_tables
    -> ;
ERROR 1046 (3D000): No database selected
mysql>

Error Code 

Please check if the database is selected 

  

   

Solution

select a database

Code Changes 

execute the following command 

  

        

mysql> use mydb
Database changed
mysql>

         

OUTPUT

Thanks for reading . Let me know your thoughts in the comments below    .