Advanced Search

fill dates MYSQL

/ Published in: MySQL
Save to your folder(s)
Not Mine but nicely done

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. CREATE PROCEDURE filldates (dateStart DATE, dateEnd DATE)
  2. BEGIN
  3.  
  4. WHILE dateStart <= dateEnd DO
  5. 	INSERT INTO workflow (workdate)
  6. VALUES
  7. 	(dateStart);
  8.  
  9.  
  10. SET dateStart = date_add(dateStart, INTERVAL 1 DAY);
  11.  
  12.  
  13. END
  14. WHILE;
  15.  
  16.  
  17. END;

URL: http://stackoverflow.com/questions/10132024/how-to-populate-a-table-with-a-range-of-dates

Report this snippet


Comments

You need to login to view comments.