mccabe615

Command Execution

exec           - Returns last line of commands output
passthru       - Passes commands output directly to the browser
system         - Passes commands output directly to the browser and returns last line
shell_exec     - Returns commands output
\`\` (backticks) - Same as shell_exec()
popen          - Opens read or write pipe to process of a command
proc_open      - Similar to popen() but greater degree of control
pcntl_exec - Executes a program

prestonp

-- returning updated values and old values by using a sub-expression

update orders
  set type = 'delivery'
  where id = 3767
  returning id, type, (
    select type from orders where id = 3767
  ) as old_type;