What causes MySQL 1451?

The row is referenced by child rows. Deleting or updating the PK would violate referential integrity.

How to fix MySQL 1451?

Delete/update child rows first. Add ON DELETE CASCADE or ON UPDATE CASCADE. Use SET FOREIGN_KEY_CHECKS=0 if safe.

MySQL 1451 — MySQL 1451 — Cannot Delete or Update Parent Row | Error Code Encyclopedia | akousa.net

SQL/Veritabanı HatalarıHata

2D000

2D000 — Invalid Transaction Termination

A transaction termination command was invalid in the current context.

postgresql

Ayrıntıları görüntüle

SQL/Veritabanı HatalarıHata

22008

22008 — Datetime Field Overflow

A datetime value is outside the valid range for the field.

postgresql

Ayrıntıları görüntüle

SQL/Veritabanı HatalarıHata

MySQL 1142

MySQL 1142 — Command Denied

The user lacks the required table-level privilege.

mysql

Ayrıntıları görüntüle

SQL/Veritabanı HatalarıHata

54000

54000 — Program Limit Exceeded

A database implementation limit was exceeded.

postgresql

Ayrıntıları görüntüle

SQL/Veritabanı HatalarıHata

SQLITE_PERM (3)

SQLITE_PERM (3) — Access Permission Denied

The requested access mode for the database file is not allowed.

sqlite

Ayrıntıları görüntüle

SQL/Veritabanı HatalarıBilgi

SQLITE_EMPTY (16)

SQLITE_EMPTY (16) — Database Is Empty

The database file exists but contains no tables.

sqlite

Ayrıntıları görüntüle

MySQL 1451 — Cannot Delete or Update Parent Row

Bu hatanın nedenleri

Nasıl düzeltilir

İlgili Hata Kodları

2D000 — Invalid Transaction Termination

22008 — Datetime Field Overflow

MySQL 1142 — Command Denied

54000 — Program Limit Exceeded

SQLITE_PERM (3) — Access Permission Denied

SQLITE_EMPTY (16) — Database Is Empty

MySQL 1451 — Cannot Delete or Update Parent Row

Bu hatanın nedenleri

Nasıl düzeltilir

İlgili Hata Kodları

2D000 — Invalid Transaction Termination

22008 — Datetime Field Overflow

MySQL 1142 — Command Denied

54000 — Program Limit Exceeded

SQLITE_PERM (3) — Access Permission Denied

SQLITE_EMPTY (16) — Database Is Empty