如何从PHP将MySql SQL_MODE设置为ANSI [英] How To Set MySql SQL_MODE to ANSI from PHP

问题描述

MySQL命令:

set @session sql_mode = ANSI;

什么是对应的PHP命令?

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'"); 

推荐答案

我最终使用mysqli_init代替了新的mysqli()，一切正常.

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

这篇关于如何从PHP将MySql SQL_MODE设置为ANSI的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！