default SQL_MODE

mathiasgrimm posted 4 years ago in General
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.

Mathias Grimm
mathiasgrimm posted 4 years ago
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 posted 4 years ago
Yes, a startup script is what you need here. Further than such a startup query, is there something else required?
mathiasgrimm posted 4 years ago
is it going to be applied in case of reconnection?

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