Skip to content

Instantly share code, notes, and snippets.

@nguyenkims

nguyenkims/generate_365_days.sql

Created April 4, 2016 10:24
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save nguyenkims/229422b8896d43aaa74bf8b9ed5a97c0 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save nguyenkims/229422b8896d43aaa74bf8b9ed5a97c0 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. nguyenkims created this gist Apr 4, 2016.
    21 changes: 21 additions & 0 deletions generate_365_days.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,21 @@

    DROP PROCEDURE IF EXISTS fillupdate;

    DELIMITER //
    CREATE PROCEDURE fillupdate()
    BEGIN
    DECLARE nbdate INT DEFAULT 0;
    DECLARE dt DATETIME DEFAULT 0;
    SET dt = '2016-01-01';

    while nbdate < 365 do
    set nbdate = nbdate + 1;
    set dt = date_add(dt, interval 1 day);
    INSERT INTO dates(dt) values(dt);

    end while;
    END;
    //
    DELIMITER ;

    call fillupdate();