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, 07:59 PM #1
- Join Date
- Nov 2010
- southwestern USA
- Thanked 34 Times in 33 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, 09: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.Be yourself. No one else is as qualified.