At Percona’s web store you can order full Percona Database Performance Audit in minutes. Find out the health of your database, and how to improve it. Pay online with a credit card. Improve your database performance now!
DELIMITER // CREATE PROCEDURE GetDatesInRange(d1 date, d2 date) BEGIN declare sd date; declare ed date; set sd = d1; set ed = d2; create table allDates ( sd DATE not null, i INT(11), t VARCHAR(255) ); while sd <= ed do insert into allDates (sd, i, t) values (sd, i, t); set sd = DATE_ADD(sd,INTERVAL 1 DAY); end while; END // DELIMITER ;
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.