SQLite refuses to enter the data and outputs an error message.
insert into flight values (600,250,'Max','Berlin','Istanbul',null);
To get the id of Sherril in the person table use
select id from person where name = 'Sherril' and residence = 'Bangalore';
Then you can perform the update with
update flight set person_id = 16, name = 'Sherril' where name = 'Evie' and start_city = 'Rabat' and dest_city = 'Doha';
Back to Tutorial