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



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.



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

Leave a comment

Leave a Reply