====== MySQL command line – quick tips ======
===== From Bash =====
==== Login (localhost access) ====
<code bash>mysql -u <userid> -p</code>

===== From the MySQL command prompt =====
==== List all databases on the current server ====
<code>mysql> show databases;</code>

==== Switch to a database ====
<code>mysql> use <db name>;</code>

==== Show all tables in the currently selected database ====
<code>mysql> show tables;</code>

==== View a table’s schema ====
<code>mysql> describe <table name>;</code>

==== Issue a select statement (example) ====
<code>mysql> select * from <table name>;</code>

==== Limit number of rows returned in a select ====
//(TOP doesn’t work in MySQL…)//

<code>mysql> select * from <table name> limit 0,10;</code>

{{tag>database}}