-- Bài 08: Bổ sung cột ngày sinh (birthday) vào bảng students và cập nhật dữ liệu
USE `labdb`;

ALTER TABLE `students` ADD COLUMN `birthday` DATE NULL;

UPDATE `students` SET `birthday` = '2004-03-15' WHERE `id` = 1;
UPDATE `students` SET `birthday` = '2004-07-22' WHERE `id` = 2;
UPDATE `students` SET `birthday` = '2003-11-08' WHERE `id` = 3;
UPDATE `students` SET `birthday` = '2004-01-30' WHERE `id` = 4;
UPDATE `students` SET `birthday` = '2005-05-19' WHERE `id` = 5;
UPDATE `students` SET `birthday` = '2003-09-12' WHERE `id` = 6;
UPDATE `students` SET `birthday` = '2004-12-25' WHERE `id` = 7;
UPDATE `students` SET `birthday` = '2004-04-04' WHERE `id` = 8;
UPDATE `students` SET `birthday` = '2005-08-14' WHERE `id` = 9;
UPDATE `students` SET `birthday` = '2003-06-28' WHERE `id` = 10;
UPDATE `students` SET `birthday` = '2004-10-03' WHERE `id` = 11;
UPDATE `students` SET `birthday` = '2004-02-17' WHERE `id` = 12;