default SQL_MODE

[expired user #7991]'s profile image [expired user #7991] posted 10 years ago in General Permalink
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
[expired user #7991]'s profile image [expired user #7991] posted 10 years ago Permalink
Actually I just found how to work around it. Is it possible to do it by adding a startup script on the session manager.

Anyway would be good to have it as configuration :)
ansgar's profile image ansgar posted 10 years ago Permalink
Yes, a startup script is what you need here. Further than such a startup query, is there something else required?
[expired user #7991]'s profile image [expired user #7991] posted 10 years ago Permalink
is it going to be applied in case of reconnection?

Please login to leave a reply, or register at first.