Solutions - Entering data

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

  2. Use

    insert into flight values (600,250,'Max','Berlin','Istanbul',null);
  3. 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