Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
Thread: type vrs engine
09-20-2013, 08:59 PM #1
- Join Date
- Nov 2010
- Thanked 32 Times in 31 Posts
type vrs engine
When did querys change from
TYPE=MyISAM to ENGINE=MyISAM ?
do i need to provide legacy code for both ways depending on the version installed on?
09-21-2013, 10:49 PM #2
No currently supported version of MySQL allows TYPE=.
Version 4.1 (remember: it is *NOT* supported) allowed *either* TYPE= or ENGINE=.
I don't know when ENGINE= was first allowed, but apparently it was even before 4.1.
Given that it's unlikely that all of your queries are going to work with any version older than 5.1, I would think there is no point in worrying about TYPE=. After all, there are SO MANY features supported in 5.x compared to earlier versions that it would be hard to be backward compatible unless all your queries are really really simplistic.
An optimist sees the glass as half full.
A pessimist sees the glass as half empty.
A realist drinks it no matter how much there is.