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