Hi

I wish to do an "ANALYZE NO_WRITE_TO_BINLOG TABLE" with dynamic table names, because table definitions change

Code:
/usr/bin/mysql -e "ANALYZE NO_WRITE_TO_BINLOG TABLE (SELECT GROUP_CONCAT(TABLE_NAME SEPARATOR ', ') FROM INFORMATION_SCHEMA.TABLES where table_schema = 'portstab')"
this generates error:

Code:
ERROR 1064 (42000) at line 1: 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 '(SELECT GROUP_CONCAT(TABLE_NAME SEPARATOR ', ') FROM INFORMATION_SCHEMA.TABLES w' at line 1
howto do that?