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:
None 
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)
Description:
In fact, even in mysql 5.0.45,
to query "SHOW TABLES NOT LIKE 'kw%'", it still raise error:

Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'not LIKE 'kw%'' at line 2

How to repeat:
To query "SHOW TABLES NOT LIKE 'kw%'".

Suggested fix:
To support this syntax.
[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.