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)
0 意見:
張貼留言