FOREIGN KEY constraint fails the cause of the error

Build table:


  
  
  
  
);
Insert data:
INSERT into Course VALUES (' 1 ', ' Database ', ' 5 ', 4);





INSERT into Course VALUES (' 7 ', ' Pascal language ', ' 6 ', 4);
Error:
Cannot add or update a child row ....
Reason:
Foreign key restrictions, cannot be inserted, in the example above is the first insert into Course VALUES (' 1 ', ' Database ', ' 5 ', 4), when the pilot course 5 does not have this option, therefore will be error, so need to adjust
The order of import is available, that is, a course without a pilot is inserted first and then inserted into a pilot and the pilot course has already been inserted.
Sentiment:
Beginner database, and fully self-study, but also need to learn!

FOREIGN KEY constraint fails the cause of the error