All geek questions in one place

How to enable STRICT_ALL_TABLES 'for a single MySQL database?

Is there a way to enable STRICT_ALL_TABLES for a single MySQL database?

+3
source share
3 answers

set sql_mode = 'STRICT_ALL_TABLES'; will do it.

+1
source

SQL , mysqld -sql-mode = "modes" sql-mode = "" my.cnf( Unix) my.ini( Windows). mode - , ( "," ). ( ). (-sql-mode = " sql-mode =" " my.cnf Unix my.ini Windows), .

ref MySql

+1

, , Strict . .

0

Source: https://habr.com/ru/post/1697839/

More articles:


All Articles