Skip to content

Instantly share code, notes, and snippets.

@phlegx
Created July 10, 2012 14:01
Show Gist options
  • Save phlegx/3083406 to your computer and use it in GitHub Desktop.
Save phlegx/3083406 to your computer and use it in GitHub Desktop.
mysql --user=root --password=xxx -Bse "select CONCAT('ALTER TABLE ', table_schema,'.', table_name,' ENGINE=NDBCLUSTER') from information_schema.tables where table_schema='waree2';" | mysql --user=root --password=xxx
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 'ALTER TABLE waree2.channelproperty ENGINE=NDBCLUSTER
ALTER TABLE switchv2.glob' at line 2
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment