Announcement

Collapse
No announcement yet.

mySQL Strict Mode

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • mySQL Strict Mode

    Strict mode controls how MySQL handles invalid or missing values in data-change statements such as INSERT or UPDATE . A value can be invalid for several reasons. For example, it might have the wrong data type for the column, or it might be out of range.

    Add to or edit your my.cnf
    Code:
    # Recommended in standard MySQL setup
    sql_mode=NO_ENGINE_SUBSTITUTION
    and restart mysql
Working...
X