query-building.sql 174 B

12345678
  1. -- name: CountPilots :one
  2. SELECT COUNT(*) FROM pilots;
  3. -- name: ListPilots :many
  4. SELECT * FROM pilots LIMIT 5;
  5. -- name: DeletePilot :exec
  6. DELETE FROM pilots WHERE id = $1;