How To Set MySql SQL_MODE to ANSI from PHP
MySQL Command:
set @session sql_mode = ANSI;
What is the c开发者_如何学Pythonorresponding PHP Command??
This Approach Does Not Seem To Work:
$conn= new mysqli("localhost", "root", "", "DB");
$conn->options(MYSQLI_INIT_COMMAND, "SET SQL_MODE = 'ANSI'");
It seems that you have missed the scope variable,try this:
SET GLOBAL SQL_MODE = 'ANSI'
Does this work for you? (Sorry, can't test at the moment)
$conn->query("set @session sql_mode = ANSI;");
I ended up using mysqli_init instead of new mysqli() and everything worked fine.
精彩评论