I hereby claim:
- I am marcusorjames on github.
- I am marcusorjames (https://keybase.io/marcusorjames) on keybase.
- I have a public key ASCX7nSLra8-Tr4YvSeeNxnhpuEGAd8G0br0_xp7g2DwXQo
To claim this, I am signing this object:
SET @DATABASE_NAME = 'name_of_your_db'; | |
SELECT CONCAT('ALTER TABLE `', table_name, '` ENGINE=InnoDB;') AS sql_statements | |
FROM information_schema.tables AS tb | |
WHERE table_schema = @DATABASE_NAME | |
AND `ENGINE` = 'MyISAM' | |
AND `TABLE_TYPE` = 'BASE TABLE' | |
ORDER BY table_name DESC; | |
# Then copy resulting queries and run |
Mon Jul 29 09:14:24 UTC 2019 |
I hereby claim:
To claim this, I am signing this object: