如何在MySQL中取消设置模式？

Question

I have used this command to use double quotes in identifiers:

set session sql_mode='ansi_quotes'

Now I want reset:

set session sql_mode =""

I think will reset all modes but I want reset only this mode.

Answer 1

You remove the ansi_quotes mode by doing another SET SESSION command. In general you might have several mode settings. If you want to selectively turn off just ansi_quotes, the following should do the trick:

SET sql_mode = (SELECT REPLACE(@@sql_mode,'ansi_quotes',''));

Read this article for more detailed information.