Issues with Setting the sql_mode Variable

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: sql_mode 变量设置问题

| username: 等一分钟

Will it fail after restarting TiDB if you set global sql_mode=''?

| username: Kongdom | Original post link

According to the documentation, it remains effective after a restart.

| username: tidb菜鸟一只 | Original post link

No, restarting or adding new TiDB nodes is still effective.
For details, please refer to

| username: zhanggame1 | Original post link

Global means it is global and permanently effective.

| username: 等一分钟 | Original post link

Thank you, everyone.

| username: Fly-bird | Original post link

Permanently effective

| username: Kongdom | Original post link

Remember to mark the best answer :wink: