Bug #46802 | request "SHOW TABLES NOT LIKE" to be supported | ||
---|---|---|---|
Submitted: | 19 Aug 2009 3:25 | Modified: | 20 Aug 2009 14:49 |
Reporter: | Malcolm Ke (kexianbin@diyism.com) | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: Information schema | Severity: | S4 (Feature request) |
Version: | 5.0, 5.1, 5.4 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[19 Aug 2009 3:25]
Malcolm Ke (kexianbin@diyism.com)
[19 Aug 2009 3:28]
Malcolm Ke (kexianbin@diyism.com)
I know we could use these instead: select table_name from information_schema.tables where table_schema = 'db_dev' and table_name not like 'kw%' but it's inconvenient and possibly privilege limited.
[19 Aug 2009 4:41]
Malcolm Ke (kexianbin@diyism.com)
Changed the version description.
[20 Aug 2009 14:49]
Susanne Ebrecht
Many thanks for writing a feature request. Verified as described.