What causes MySQL 1364?

In STRICT mode, MySQL requires explicit values for every NOT NULL column without DEFAULT.

How to fix MySQL 1364?

Provide values for all NOT NULL columns. Add DEFAULT values. Adjust sql_mode if implicit defaults are acceptable.

MySQL 1364 — MySQL 1364 — Field Has No Default Value | Error Code Encyclopedia | akousa.net

Errores de SQL/Base de DatosError

MySQL 1040

MySQL 1040 — Too Many Connections

The maximum number of MySQL connections has been exceeded.

mysql

Ver detalles

Errores de SQL/Base de DatosError

42804

42804 — Datatype Mismatch

The data types in the expression are incompatible.

postgresql

Ver detalles

Errores de SQL/Base de DatosError

SQLITE_AUTH (23)

SQLITE_AUTH (23) — Authorization Denied

The authorizer callback denied the operation.

sqlite

Ver detalles

Errores de SQL/Base de DatosError

MySQL 1169

MySQL 1169 — Unique Constraint Violated on Write

A write to a unique index with IGNORE was skipped.

mysql

Ver detalles

Errores de SQL/Base de DatosError

SQLITE_NOLFS (22)

SQLITE_NOLFS (22) — Large File Support Not Available

The platform does not support large files required by the database.

sqlite

Ver detalles

Errores de SQL/Base de DatosFatal

57P02

57P02 — Crash Shutdown

The database server crashed and is restarting.

postgresql

Ver detalles

MySQL 1364 — Field Has No Default Value

Qué causa este error

Cómo solucionarlo

Códigos de Error Relacionados

MySQL 1040 — Too Many Connections

42804 — Datatype Mismatch

SQLITE_AUTH (23) — Authorization Denied

MySQL 1169 — Unique Constraint Violated on Write

SQLITE_NOLFS (22) — Large File Support Not Available

57P02 — Crash Shutdown

MySQL 1364 — Field Has No Default Value

Qué causa este error

Cómo solucionarlo

Códigos de Error Relacionados

MySQL 1040 — Too Many Connections

42804 — Datatype Mismatch

SQLITE_AUTH (23) — Authorization Denied

MySQL 1169 — Unique Constraint Violated on Write

SQLITE_NOLFS (22) — Large File Support Not Available

57P02 — Crash Shutdown