MySQL: Use ENGINE instead of deprecated TYPE for storage-engine
CREATE-statements often still use TYPE instead of ENGINE. Since those statements are analysed already it should be possible to substitute this parameter quite easy.
I just had CREATE-statements failing (!) because of TYPE being used on MySQL 5.5.something. I can't say exactly since when it was dropped finally but it's definitely deprecated since 4.x
http://dev.mysql.com/doc/refman/4.1/en/create-table.html states “ENGINE was added in MySQL 4.0.18 (for 4.0) and 4.1.2 (for 4.1).” and then notes that TYPE is deprecated
Updated by Jigal van Hemert over 10 years ago
- Incompatible change: As of MySQL 5.1.8, TYPE = engine_name is still accepted as a synonym for the ENGINE = engine_name table option but generates a warning. You should note that this option is not available in MySQL 5.1.7, and is removed altogether in MySQL 5.5 and produces a syntax error.
TYPE has been deprecated since MySQL 4.0.