Guest User

Untitled

a guest
Jan 21st, 2019
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.44 KB | None | 0 0
  1. UPDATE tasks,components
  2. INNER JOIN presets ON presets.id = tasks.id_preset
  3. INNER JOIN preset_values ON preset_values.id_preset = presets.id
  4. INNER JOIN preset_values AS pv2 ON pv2.serial_number = components.serial_number
  5. SET tasks.start_date = DATE_ADD(
  6. tasks.start_date, INTERVAL tasks.frequency SECOND
  7. ),
  8. components.value = pv2.value,
  9. components.state = pv2.on_off
  10. WHERE tasks.start_date <= CURRENT_DATE AND tasks.hour <= CURRENT_TIME
Add Comment
Please, Sign In to add comment