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