How do I select a MySQL database through CLI

Question

I ve managed to get into MySQL using the command line terminal  but when I tried to enter some SQL  it said  no database selected   how do I select a database  my database name is   photogallery  What code do I use to select it

User · Answer

While invoking the mysql CLI  you can specify the database name through the -D option   From mysql --help  -D  --database name Database to use   I use this command  mysql -h  lt db host gt  -u  lt user gt  -D  lt db name gt  -p

User · Answer

Use USE  This will enable you to select the database   USE photogallery       12 8 4  USE Syntax   You can also specify the database you want when connecting     mysql -u user -p photogallery

User · Answer

USE database name   eg  if your database s name is gregs list  then it will be like this  gt  gt  USE gregs list

User · Answer

Hope this helps   use  YOUR DB NAME

User · Answer

Alternatively  you can give the  full location  to the database in your queries a la   SELECT photo id FROM  my database name  photogallery    If using one more often than others  use USE   Even if you do  you can still use the database table syntax

User · Answer

Use the following steps to select the database   mysql -u username -p   it will prompt for password  Please enter password  Now list all the databases  show databases    select the database which you want to select using the command   use databaseName    select data from any table   select   from tableName limit 10    You can select your database using the command use photogallery  Thanks

User · Answer

Switch to a database    mysql  use  db name     MySQL Commands

[mysql] How do I select a MySQL database through CLI?

Examples related to mysql