[mysql] change datebases

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| testdb             |
+--------------------+
3 rows in set (0.00 sec)

mysql> use testdb;

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A



Database changed


mysql> show tables;

+------------------+

| Tables_in_testdb |

+------------------+

| Authors          |

| Books            |

| Images           |

| Testing          |

+------------------+

4 rows in set (0.00 sec)




mysql> select * from Authors;

+----+--------------------+

| Id | Name               |

+----+--------------------+

|  1 | Jack London        |

|  2 | Honore de Balzac   |

|  3 | Lion Feuchtwanger  |

|  4 | Emile Zola         |

|  5 | Truman Capote      |

|  6 | Trygve Gulbranssen |

|  7 | Trygve Gulbranssen |

|  8 | Trygve Gulbranssen |

|  9 | Luke               |

| 10 | Luke               |

| 11 | Luke               |

+----+--------------------+

11 rows in set (0.00 sec)