789_create_teachers.sql

INSERT INTO `user` (`username`, `password`, `fullname`, `cell_phone`, `email`, `address`, `gender`, `group_id`) 
VALUES 
('[email protected]','b5197ac6bb6ccf57c9ad54845e1fcb11', 'Đinh Thị Trúc Ly', '01232615623', '[email protected]', 'phan văn trị', 'F', 3),
('[email protected]','b5197ac6bb6ccf57c9ad54845e1fcb11', 'Lê thanh hưng', '0942289217', '[email protected]', '', 'M', 3),
('[email protected]','b5197ac6bb6ccf57c9ad54845e1fcb11', 'Trần Thị Thanh Trúc', '0915737894', '[email protected]', 'Nguyễn Ngọc Thăng', 'F', 3),
('[email protected]','b5197ac6bb6ccf57c9ad54845e1fcb11', 'Khưu Ngọc Thanh', '01273364166', '[email protected]', '', 'M', 3),
('[email protected]','b5197ac6bb6ccf57c9ad54845e1fcb11', 'Nguyễn Thị Ngọc Duyên', '0907026394', '[email protected]', '', 'F', 3),
('[email protected]','b5197ac6bb6ccf57c9ad54845e1fcb11', 'Phan trung hậu', '', '[email protected]', 'pvt', 'M', 3),
('[email protected]','b5197ac6bb6ccf57c9ad54845e1fcb11', 'Nguyễn Duy Trinh', '', '[email protected]', '', 'M', 3),
('[email protected]','b5197ac6bb6ccf57c9ad54845e1fcb11', 'Nguyễn Tấn Tiến', '', '[email protected]', 'Nguyễn Trãi', 'M', 3),
('[email protected]','b5197ac6bb6ccf57c9ad54845e1fcb11', 'Phạm thanh ba', '', '[email protected]', 'Nguyễn Trãi', 'M', 3),
('[email protected]','b5197ac6bb6ccf57c9ad54845e1fcb11', 'Huỳnh kim thanh', '', '[email protected]', 'Nguyễn Thị Định', 'M', 3),
('[email protected]','b5197ac6bb6ccf57c9ad54845e1fcb11', 'trần thị mỹ linh', '', '[email protected]', 'pvt', 'F', 3),
('[email protected]','b5197ac6bb6ccf57c9ad54845e1fcb11', 'lê phạm thành khoa', '', '[email protected]', 'Nguyễn Thị Định', 'M', 3),
('[email protected]','b5197ac6bb6ccf57c9ad54845e1fcb11', 'võ thị Kim Tuyến', '0945156578', '[email protected]', '', 'M', 3),
('[email protected]','b5197ac6bb6ccf57c9ad54845e1fcb11', 'Kim loan', '01234030700', '[email protected]', '', 'F', 3),
('[email protected]','b5197ac6bb6ccf57c9ad54845e1fcb11', 'Nghĩa', '0985419823', '[email protected]', '', 'M', 3),
('[email protected]','b5197ac6bb6ccf57c9ad54845e1fcb11', 'Tuyết', '0985965636', '[email protected]', '', 'F', 3),
('[email protected]','b5197ac6bb6ccf57c9ad54845e1fcb11', 'Tấn Khương', '0986050025', '[email protected]', '', 'M', 3),
('[email protected]','b5197ac6bb6ccf57c9ad54845e1fcb11', 'trương thị Mỹ Linh', '0987239141', '[email protected]', 'pvt', 'F', 3),
('[email protected]','b5197ac6bb6ccf57c9ad54845e1fcb11', 'Đặng thanh trung', '0976765404', '[email protected]', 'pvt', 'M', 3),
('[email protected]','b5197ac6bb6ccf57c9ad54845e1fcb11', 'Nguyễn Văn Nhân', '01206351592', '[email protected]', 'Nguyễn Trãi', 'M', 3),
('[email protected]','b5197ac6bb6ccf57c9ad54845e1fcb11', 'Võ Hoàng Thuý Châu', '01654737366', '[email protected]', 'Nguyễn Ngọc Thăng', 'F', 3),
('[email protected]','b5197ac6bb6ccf57c9ad54845e1fcb11', 'Nguyễn Thị minh Châu', '0918190157', '[email protected]', 'Nguyễn Ngọc Thăng', 'F', 3),
('[email protected]','b5197ac6bb6ccf57c9ad54845e1fcb11', 'Võ Văn hoàng', '01238745144', '[email protected]', 'Phó hiểu trưởng PVT', 'M', 3);

UPDATE user
SET username = '[email protected]', email = '[email protected]'
WHERE username = '[email protected]';