4 ms·
I think it's fairer to say that: it doesnt necessarily implement them in a standards-compliant way. Which I dont mean to imply it implements everything, in a n
by hughperkins 11y ago
I think it's fairer to say that: it doesnt necessarily implement them in a standards-compliant way. Which I dont mean to imply it implements everything, in a non-standard way, it's missing a bunch of stuff. But it does have a lot of standard database features, like transactions and so on, but a lot of stuff is ... odd. for example, 'row_number()' is missing. You have to use session variables.
- mamon 11y ago"Non-standards-compliant way" is the long-time default engine, MyISAM not supporting transactions and locking. Fortunately they moved to InnoDB as default recently, but the very fact that it took them so long tells much about their attitude towards DB standards compliance.