Solutions-Entering data

 

40. SQLite refuses to enter the data and outputs an error message.

41. Use

insert into flight values (600,250,'Max','Berlin','Istanbul',null);

42. 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