queries.sql 301 B

12345678910111213
  1. -- :name get-worlds :? :*
  2. SELECT * FROM "World"
  3. WHERE id IN (:v*:ids)
  4. --:name get-all-fortunes :? :*
  5. -- select all records from the fortune table
  6. SELECT * FROM "Fortune"
  7. -- :name update-world! :! :1
  8. -- update an existing world record
  9. UPDATE "World"
  10. SET "randomnumber" = :randomNumber
  11. WHERE id = :id