4 ms·
Strict should be the default for something that stores your data. The SQL standard does not allow selects like that for a a reason. Indeterminate results are al
by matwood 11y ago
Strict should be the default for something that stores your data. The SQL standard does not allow selects like that for a a reason. Indeterminate results are almost always bad for something that stores data. MySql is that bad [1] and was only used by people who knew nothing about databases to question all of the dumb things MySql did. I'm so happy postgresql is finally getting popular.
FB also uses php, so appealing to it being used is no argument.
[1] http://grimoire.ca/mysql/choose-something-else http://grimoire.ca/mysql/choose-something-else
- morgo 11y agoAs I commented in the parent: it is the default. It was enabled for new installs in MySQL 5.6, and all installs from MySQL 5.7.