问题出现系统:WIN10 x64
问题出现MYSQL版本:5.7.24
SQL如下:
SHOW TABLES
WHERE
`Tables_in_cloud` LIKE '%device_info_%'
AND `Tables_in_cloud` != 'device_info_day'
ORDER BY
`Tables_in_cloud` ASC
错误信息:navicat报错 1064,JDBC报错#42000
望有大神路过能解答原理~~
20230808173014:MariaDB中表明了“SHOW TABLES”只能用“LIKE”去匹配表,因为列表的列名称总会改变,所以无法使用where去匹配。最后只能使用这个方式:
SELECT table_name AS address_tables
FROM information_schema.tables
WHERE table_name LIKE 'address_%';