Change SQL Mode in MySQL 8 for Mac
The SQL mode settings between Windows and Mac community edition 8 are different. This can cause differing results when the same query is run in the two environments. This video shows how to set the Mac settings to mirror the default of Windows. A different video shows how to change the Windows settings to mirror the Mac default.
The setting string from the Windows configuration to input to the Mac config file is: ’STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION’
Very important that it begins and ends with single quotes and the phrases are separated by a comma.
The video showing how the change the Windows settings to be the same as the Mac default can be seen at • Change SQL Mode in MySQL 8 for Windows