How To Set MySql SQL_MODE to ANSI from PHP.

Question

MySQL Command:

set @session sql_mode = ANSI;

What is the corresponding PHP Command??

This Approach Does Not Seem To Work:

$conn= new mysqli("localhost", "root", "", "DB");
$conn->options(MYSQLI_INIT_COMMAND, "SET SQL_MODE = 'ANSI'"); 

Answer 1

It seems that you have missed the scope variable,try this:

SET GLOBAL SQL_MODE = 'ANSI'

Answer 2

Does this work for you? (Sorry, can't test at the moment)

$conn->query("set @session sql_mode = ANSI;");

Answer 3

I ended up using mysqli_init instead of new mysqli() and everything worked fine.