My MySQL server’s sql_mode setting is set to STRICT. I want to change it to TRADITIONAL for a particular application I’m developing. However it’s not possible for me to do this at the server level.
Is it possible to change the sql_mode setting at runtime from my PHP scripts?
Advertisement
Answer
Hmm this should work
// connect to mysql and call the first query mysqli_query($conn, "SET SESSION sql_mode = 'TRADITIONAL'");