Sqlite Error : FOREIGN KEY constraint failed

Question

I am trying to update the employee data in sqlite. Employee ssn number of two data is mistakenly swapped and now when i try to swap the data again with the code below:

UPDATE employee SET SSN=’666884444’  WHERE SSN = ‘123456789’; 
UPDATE employee SET SSN=’123456789’ WHERE SSN = ‘666884444’;

it shows me the following error:

[16:51:19] Error while executing SQL query on database 'Company': 
FOREIGN KEY constraint failed

Can someone please guide me with the query?

One of those numbers probably doesn't exist in the table that employee.ssn is related too. You can temporarily turn off foreign key checks with a pragma and turn them back on after doing this. — Shawn
– Shawn, Commented Aug 22, 2018 at 8:18
Also, I don't think that attempt to swap will actually work. — Shawn
– Shawn, Commented Aug 22, 2018 at 8:18

RonJohn · Accepted Answer · 2018-08-22 12:42:09Z

0

https://www.sqlite.org/foreignkeys.html

Change the FK constraint to DEFERRED. Syntax is DEFERRABLE INITIALLY DEFERRED.
Do your updates inside a BEGIN/COMMIT transaction block.

answered Aug 22, 2018 at 12:42

RonJohn

4533 gold badges9 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Sqlite Error : FOREIGN KEY constraint failed

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related