Database update query's.

    So if the year is set for the tracks on 2016, 2015, 2013 ect. run the query(s) in Januari 2017.

    It will only work if the start day number and mouth numbers are the same.


    Query to update christmas tracks with a start and end date.

    Update for christmas days update songs set start_date=date_add(start_date,interval 1 year),end_date=date_add(end_Date,interval 1 year),enabled=1 where dayofmonth(start_date)=15 and month(start_date)=12 and year(start_date)=year(now())-1;

    Note: edit/set the number of the start day in the file if it is not your start day of the tracks!
    dayofmonth(start_date)=15 (15 is the day number).

    Christmas.sql

    Use right click and save as.


    Query to update halloween tracks with a start and end date.

    Update for Halloween day update songs set start_date=date_add(start_date,interval 1 year),end_date=date_add(end_Date,interval 1 year),enabled=1 where dayofmonth(start_date)=31 and month(start_date)=10 and year(start_date)=year(now())-1;

    Halloween.sql

    Use right click and save as.


Back to top
©  JWL  2013 | 2017