MariaDB [jikedb]> show tables;
+------------------+
| Tables_in_jikedb |
+------------------+
| addressbook |
| forums |
| leibusi |
| new |
| table_string |
| tabledata |
| tabledate |
| tbl_user |
| users |
| xiaomi_com |
| yiwan |
+------------------+
11 rows in set (0.00 sec)
MariaDB [jikedb]> select * from addressbook;
+-------+-------+-------+------+-----------------+
| fname | lname | phone | fax | email |
+-------+-------+-------+------+-----------------+
| lames | Boss | 123 | 234 | 123@jikexueyuan |
| Jake | Mike | NULL | NULL | NULL |
| Jam | Bob | 123 | 234 | 23@jikexueyuan |
| lames | Boss | 123 | 234 | 23@jikexueyuan |
| Jam | Bob | 123 | 234 | 23@jikexueyuan |
| jck | NULL | NULL | NULL | NULL |
+-------+-------+-------+------+-----------------+
6 rows in set (0.00 sec)
MariaDB [jikedb]> select * from forums;
+-------+----------+--------------+
| name | category | postsPerpage |
+-------+----------+--------------+
| hello | UNIX | 15 |
| hello | windows | 20 |
+-------+----------+--------------+
2 rows in set (0.00 sec)
MariaDB [jikedb]> se
+------------------+
| Tables_in_jikedb |
+------------------+
| addressbook |
| forums |
| leibusi |
| new |
| table_string |
| tabledata |
| tabledate |
| tbl_user |
| users |
| xiaomi_com |
| yiwan |
+------------------+
11 rows in set (0.00 sec)
MariaDB [jikedb]> select * from addressbook;
+-------+-------+-------+------+-----------------+
| fname | lname | phone | fax | email |
+-------+-------+-------+------+-----------------+
| lames | Boss | 123 | 234 | 123@jikexueyuan |
| Jake | Mike | NULL | NULL | NULL |
| Jam | Bob | 123 | 234 | 23@jikexueyuan |
| lames | Boss | 123 | 234 | 23@jikexueyuan |
| Jam | Bob | 123 | 234 | 23@jikexueyuan |
| jck | NULL | NULL | NULL | NULL |
+-------+-------+-------+------+-----------------+
6 rows in set (0.00 sec)
MariaDB [jikedb]> select * from forums;
+-------+----------+--------------+
| name | category | postsPerpage |
+-------+----------+--------------+
| hello | UNIX | 15 |
| hello | windows | 20 |
+-------+----------+--------------+
2 rows in set (0.00 sec)
MariaDB [jikedb]> se