MYSQL 命令备忘

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| dboa               |
| guangdian          |
| mysql              |
| test               |
+--------------------+
5 rows in set (0.03 sec)

mysql> use dboa
Database changed
mysql> show tables;
+----------------------------+
| Tables_in_dboa             |
+----------------------------+
| archives                   |
| array                      |
| bulletin                   |
| calendar                   |
| datereport                 |
| dayresult                  |
| dept                       |
| deptbulletin               |
| districtmap                |
| douleaderpostil            |
| doureportmethod            |
| employee                   |
| employeerole               |
| floder                     |
| folder                     |
| instantcommunicateiconinfo |
| instantcommunicaterecord   |
| instantcommunicateuserinfo |
| leaderpostil               |
| method                     |
| power                      |
| powerrole                  |
| privateaddressbook         |
| reportleader               |
| reportmethod               |
| reporttype                 |
| role                       |
| sbd2                       |
| siteinfo                   |
| statreport                 |
| statreport_p               |
| statresult                 |
| sysreport                  |
| sysreport_p                |
| weekreport                 |
| weekresult                 |
| yintest                    |
+----------------------------+
37 rows in set (0.02 sec)