### SQL

Log into database: `mysql [db_name]`

View a table: `SELECT * FROM table_name;`

Update a record in a table:

`UPDATE [table_name] SET [table_column] = NOW() WHERE id = 1;`

For Action Plans

table_name = `users_tasks`

Order table view

`SELECT * FROM users_tasks ORDER BY timestamp_due ASC;`

Change the time for a task

`UPDATE users_tasks SET timestamp_due = NOW() - INTERVAL 8 HOUR + 200 WHERE id = 7`