Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /*
- socialcliro@production/social> select * from schedule_entry where id = 1221;
- +------+----------------+---------------------+---------------------+------------------------+------------+---------------+
- | id | competition_id | creation_date | game_start_date | game_start_day_of_week | game_label | contest_label |
- +------+----------------+---------------------+---------------------+------------------------+------------+---------------+
- | 1221 | 68 | 2019-01-15 09:00:00 | 2019-01-18 21:00:00 | 6 | NULL | NULL |
- +------+----------------+---------------------+---------------------+------------------------+------------+---------------+
- 1 row in set (0.00 sec)
- */
- begin;
- update schedule_entry set creation_date = date_add(creation_date, interval 1 day) where id = 1221;
- commit;
Add Comment
Please, Sign In to add comment