Examples and Notes by Week

↑ Up to Parent directory
View Create_GetCustomerLevel.sql code.	Open/Save Create_GetCustomerLevel.sql.
View Create_GetCustomerLevel2.sql code.	Open/Save Create_GetCustomerLevel2.sql.
View Create_GetCustomerLevel3.sql code.	Open/Save Create_GetCustomerLevel3.sql.
View Create_GetCustomerShipping.sql code.	Open/Save Create_GetCustomerShipping.sql.
View Create_GetCustomers.sql code.	Open/Save Create_GetCustomers.sql.
View Create_GetOfficeByCountry.sql code.	Open/Save Create_GetOfficeByCountry.sql.
View Create_GetOrderCountByStatus.sql code.	Open/Save Create_GetOrderCountByStatus.sql.
View Create_GetTotalOrde_sessionr.sql code.	Open/Save Create_GetTotalOrde_sessionr.sql.
View Create_GetTotalOrder.sql code.	Open/Save Create_GetTotalOrder.sql.
View GetAllProducts.sql code.	Open/Save GetAllProducts.sql.
View LoopDemo.sql code.	Open/Save LoopDemo.sql.
View exit_handler.sql code.	Open/Save exit_handler.sql.
View while.sql code.	Open/Save while.sql.

The code for while.sql is:
CREATE TABLE calendars( id INT AUTO_INCREMENT, fulldate DATE UNIQUE, day TINYINT NOT NULL, month TINYINT NOT NULL, quarter TINYINT NOT NULL, year INT NOT NULL, PRIMARY KEY(id) ); DELIMITER $$ CREATE PROCEDURE InsertCalendar(dt DATE) BEGIN INSERT INTO calendars( fulldate, day, month, quarter, year ) VALUES( dt, EXTRACT(DAY FROM dt), EXTRACT(MONTH FROM dt), EXTRACT(QUARTER FROM dt), EXTRACT(YEAR FROM dt) ); END$$ DELIMITER ; DELIMITER $$ CREATE PROCEDURE LoadCalendars( startDate DATE, day INT ) BEGIN DECLARE counter INT DEFAULT 1; DECLARE dt DATE DEFAULT startDate; WHILE counter <= day DO CALL InsertCalendar(dt); SET counter = counter + 1; SET dt = DATE_ADD(dt,INTERVAL 1 day); END WHILE; END$$ DELIMITER ; CALL LoadCalendars('2019-01-01',31);