Skip to content

Instantly share code, notes, and snippets.

@cdolek
Last active August 29, 2015 14:16
Show Gist options
  • Save cdolek/e29edac9fcc37ede95b0 to your computer and use it in GitHub Desktop.
Save cdolek/e29edac9fcc37ede95b0 to your computer and use it in GitHub Desktop.
convert innodb to myisam - alter table print
SELECT
CONCAT(
'ALTER TABLE ',
TABLE_SCHEMA,
'.',
TABLE_NAME,
' ENGINE = MyISAM;'
)
FROM
information_schema. TABLES
WHERE
ENGINE = 'InnoDB'
AND TABLE_SCHEMA NOT IN (
'mysql',
'information_schema',
'performance_schema'
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment