troubleshooting Question

MySQL: Error 1442 in a SELECT

Avatar of formi
formiFlag for Switzerland asked on
MySQL Server
3 Comments1 Solution10 ViewsLast Modified:

I have the following code to insert all missing rows (only rows that are actually not in the table):
INSERT INTO myDetailTable(Field1, Field2)
      SELECT A.Field1, C.FieldX FROM myMasterTable A
      INNER JOIN myThirdTable C
      LEFT JOIN myDetailTable E ON E.Id = C.Id AND E.aField = A.aField
Here I get the error 1442 (an't update table 'myDetailTable ' in stored function/trigger because it is already used by statement which invoked this stored function/trigger). I have with other tables the same select and there it works. I don't see the reasion. Thanks, Peter


Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros