Issue Bug Closed

#50466MySQL: Use ENGINE instead of deprecated TYPE for storage-engine

Stefan Neufeind 07/26/13, 14:25 updated 10/02/18, 12:12

Description

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

Reviews 5