[DB] Server SQL Modes

The Most Important SQL Modes

The most important sql_mode values are probably these:

• ANSI
• This mode changes syntax and behavior to conform more closely to standard SQL. It is one of the special combination modes listed at the end of this section.
• STRICT_TRANS_TABLES
• If a value could not be inserted as given into a transactional table, abort the statement. For a nontransactional table, abort the statement if the value occurs in a single-row statement or the first row of a multiple-row statement. More details are given later in this section.
• TRADITIONALNote
• With TRADITIONAL mode enabled, an INSERT or UPDATE aborts as soon as an error occurs. If you are using a nontransactional storage engine, this may not be what you want because data changes made prior to the error may not be rolled back, resulting in a “partially done” update.
• Make MySQL behave like a “traditional” SQL database system. A simple description of this mode is “give an error instead of a warning” when inserting an incorrect value into a column. It is one of the special combination modes listed at the end of this section.

When this manual refers to “strict mode,” it means a mode with either or both STRICT_TRANS_TABLES or STRICT_ALL_TABLES enabled.

 

docs.oracle.com/cd/E17952_01/mysql-5.6-en/sql-mode.html#sql-mode-setting

5.1.10 Server SQL Modes

dev.mysql.com/doc/refman/8.0/en/sql-mode.html

MySQL :: MySQL 8.0 Reference Manual :: 5.1.11 Server SQL Modes

study-ymj.tistory.com/entry/mysql%EC%97%90%EC%84%9C-int-%EC%9E%90%EB%A3%8C%ED%98%95%EC%97%90-string%EC%9D%84-%EB%84%A3%EC%9C%BC%EB%A9%B4-%EB%93%A4%EC%96%B4%EA%B0%88%EA%B9%8C

mysql에서 int 자료형에 string을 넣으면 들어갈까?