CRUD SQL

examples.rb

# http://airbnb.com/flats/42

SELECT * FROM flats
WHERE id = 42

# https://github.com/users/jonnygates

SELECT * FROM users
WHERE username = 'jonnygates'

# Gmail Delete

UPDATE messages SET deleted=true WHERE id = 3

# SQL Injection Protection
DB.execute('SELECT * FROM users WHERE id = ?', 3)
DB.execute('UPDATES users SET username = ?, age = ? WHERE id = ?','jonnygates', 30, 3)