How to fix error in mysql: ERROR 1452 (23000) CONSTRAINT ?

Quick Help

Knowledgebase is a categorized collection of answers to frequently asked questions (FAQ) and articles. You can read articles in this category or select a subcategory that you are interested in.

How to fix error in mysql: ERROR 1452 (23000) CONSTRAINT ?

Solution

use this command to find the rows that need to be deleted:

select * from orders where cid not in (select distinct id from customers);

Was this article helpful? yes / no

Article details

Article ID: 10

Category: MySQL

Date added: 2020-01-13 11:05:49

Rating (Votes): (3)

How to fix issue in mysql import CREATE ALGORITHM=UNDEFINED DEFINER=?
ERROR 1118 (42000) at line 1852: Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
How to fix cron jobs issue in magento 2?

How to fix error in mysql: ERROR 1452 (23000) CONSTRAINT ?

Solution

Article details

Related articles