MySQL Clients: Setting connection to DB

This entry is part 6 of 8 in the series MySQL Clients

For MySQL console, it is easy to connect to the DB.

As I have already created the database allartist, I need only to execute the command:

mysql> connect allartist

mysql_connect

 

Now I can do a select * from artist to display nicely the data in the table artist.

Note that you need to type in \g to execute the command.

console_select

 

Series Navigation<< MySQL Clients: Using the console
MySQL Clients: Dropping DB and table >>