marcusorjames

## myisam_to_innodb.sql
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

## bumpme
Mon Jul 29 09:14:24 UTC 2019

## keybase.md

      
        
          
            
              
              1 file
            
          
          
            
              
              0 forks
            
          
          
            
              
              0 comments
            
          
          
            
              
              0 stars
            
          
        
        
          
              
          
          
            
                marcusorjames
                / keybase.md
            
            
              Created
              August 18, 2016 10:14
            
              
                Keybase auth
              
          
        
      
        
  
      
    Keybase proof

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