title: SQLITE update, limit, case
body: <p><img src="https://i.stack.imgur.com/DikvR.jpg" alt="enter image description here">i want to implement a parking lot application 
  so there is a garage with 5 or more parking lots 
  when the driver parks his car the next free slot in the garage should be assigned to him.</p>
  
  <p>so i have a table garage with 5 or more slots 
   i have the problem when i update 
                     update garage set free = 0, set car = 1 (car_id) then all free slots are update how can i limit only to update the first free row? </p>
  
  <p>Can anyone help me </p>
  
  <p>thanks in advance (false) 
  Thanks
  i have garage table with levels and slots in each level when i park a car i want to update just the free slots </p>
  
  <p><img src="https://i.stack.imgur.com/KAe94.jpg" alt="table garage"></p>