Hi guys,
First I would like to thank.
This tool is really nice and I have been using it for 6 months and recommending to all my friends. Well Done!
There is a setting for MySql call sql_mode, it is possible to define it on my.cnf or via every connection(I use this way inside my connection class)
The problem is that I haven't seen this configuration on HeideSQL. Would be really handy to have it...
I use SET SQL_MODE='TRADITIONAL' because it avoids some mistakes and make the database work as a real database (not allowing null for not null, not allowing 0000 for date columns and so on)
Let me know if we have something that I can to to workaround it or let me know if we are going to have this feature.
Basically we need some queries to run once when we connect or reconnect.
Thanks
Mathias Grimm