8 Nov
2005
8 Nov
'05
2:49 a.m.
Hi there,
Marc Delisle schrieb:
Starting with MySQL 4.1, we can switch the mode. In fact, we are already doing it in libraries/export/sql.php. But what if the user or sysadmin really wants to check the behavior in ANSI mode? Forcing the mode to non-script would block users to verify this behavior.
I meant "non-strict"!
You're right, I did not think of this. So maybe, we should add a dropdown box to our SQL input boxes and the file upload dialog, that allows the user to choose the desired SQL mode. The default value should be the actual SQL mode of the current server.
It shouldn't be problematic to switch the SQL mode before and after executing the user's commands.
Regards,
AMT