我想查出某数据库(MySQL)中有数据的表,我的想法是先查初该数据库中所有的表,然后通过循环查询(slect count(1))每个表,来的得出有记录的表。
具体该怎么写这个循环呢?
我知道通过select TABLE_NAME from tables where TABLE_SCHEMA='database_name'; 可以查询出所有的表。
mysql> use information_schema;
Database changed
mysql> select TABLE_NAME from tables where TABLE_SCHEMA='database_name'';
+---------------------------+
| TABLE_NAME |
+---------------------------+
| Advertisement |
| BlackList |
| Browser |
| BrowserOS |
| ClickLog |
| ClickThroughLog |
| CustomEvent |
| CustomEventLog |
| CustomEventMetadata |
| DailyBrowserLogInfo |
| DailyBrowserOSLogInfo |
| DailyClickLogInfo |
| DailyClickThroughLogInfo |
| DailyCustomEventLogInfo |
| DailyFlashLogInfo |
| DailyGeolocationLogInfo |
| DailyLanguageLogInfo |
| DailyOSLogInfo |
| DailyViewPlacementLogInfo |
| Domain |
| DomainCategory |
| Flash |
| Geolocation |
| LocalizationLanguage |
| LogInfoTime |
| Os |
| Parameter |
| Placement |
| PlacementParameter |
| Spinlet |
| SpinletAdvertisement |
| Tag |
| URLInfo |
| User |
| ViewLog |
| ViewSessionLog |
+---------------------------+
36 rows in set (0.00 sec)
[本帖最后由 fush_oracle 于 2008-4-17 18:20 编辑]