git notes

Git, delete all deleted files

# git rm $(git ls-files --deleted)

Switch to other branch

# git branches
  Master
  Dev1
* Dev2

# git checkout Master
Branch Master set up to track remote branch Master from origin.
Switched to a new branch 'Master'

# git branches
* Master
  Dev1
  Dev2

Mysql / MariaDB check tables engine

SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'dbname' AND engine = 'MyISAM';


Where dbname - database name
And InnoDB - engine, you can use InnoDB


Convert MyISAM tables to InnoDB

SELECT CONCAT('ALTER TABLE ', TABLE_SCHEMA, '.', TABLE_NAME,' ENGINE=InnoDB;')
FROM Information_schema.TABLES WHERE TABLE_SCHEMA = 'DBNAME' AND ENGINE = 'MyISAM' AND TABLE_TYPE = 'BASE TABLE'

Then run result as SQL query

For example:

 ALTER TABLE databasename.tablename ENGINE=InnoDB;