lenhsql.sql

--Tao du lieu sinh vien cho mysql--

INSERT INTO qlsv.student (Dep, StudentID, Name, Division, Gender, email ,DOB, Grade, gpa,Credits, scholarship) VALUES 
('Electrical Engineering', '21021514' ,'Nguyễn Thị Giang', 'Class2', 'Female','giang@gmail.com', '2002-05-14', 6.8 , 0.0 ,94, 'None'),
('Electrical Engineering', '21021501' ,'Nguyễn Thị Lan', 'Class1', 'Female','lan@gmail.com', '2002-05-15', 6.9 , 0.0 ,95, 'None'),
('Telecomunication Engineering', '21021502' ,'Nguyễn Thị Chi', 'Class2', 'Female','chi@gmail.com', '2002-05-16', 7.0 , 0.0 ,96, 'None'),
('Electrical Engineering', '21021503' ,'Nguyễn Thị Mai', 'Class2', 'Female','mai@gmail.com', '2002-05-17', 7.1 , 0.0 ,97, 'None'),
('Telecomunication Engineering', '21021504' ,'Nguyễn Thị Phượng', 'Class1', 'Female','phuongnguyen@gmail.com', '2002-05-18', 7.2 , 0.0 ,98, 'None'),
('Electrical Engineering', '21021505' ,'Nguyễn Thị Hoài', 'Class2', 'Female','hoai@gmail.com', '2002-05-19', 7.3 , 0.0 ,99, 'None'),
('Telecomunication Engineering', '21021506' ,'Nguyễn Thị Thương', 'Class1', 'Female','thuong@gmail.com', '2002-05-20', 7.4 , 0.0 ,100, 'None'),
('Electrical Engineering', '21021507' ,'Đoàn Thị Giang', 'Class2', 'Female','doangiang@gmail.com', '2002-05-21', 7.5 , 0.0 ,93, 'None'),
('Telecomunication Engineering', '21021508' ,'Lê Thị Giang', 'Class1', 'Female','legiang@gmail.com', '2002-05-22', 7.9 , 0.0 ,92, 'None'),
('Telecomunication Engineering', '21021509' ,'Nguyễn Thị Linh Chi', 'Class2', 'Female','linhchi@gmail.com', '2002-05-23', 8.0 , 0.0 ,91, 'None'),
('Electrical Engineering', '21021510' ,'Ngô Thị Mai', 'Class1', 'Female','maingo@gmail.com', '2002-05-24', 8.1 , 0.0 ,90, 'None'),
('Electrical Engineering', '21021511' ,'Trần Thị Quỳnh', 'Class2', 'Female','tranquynh@gmail.com', '2002-05-25', 8.2 , 0.0 ,80, 'None'),
('Telecomunication Engineering', '21021512' ,'Nguyễn Thị Như', 'Class2', 'Female','nhunguyen@gmail.com', '2002-05-26', 6.5 , 0.0 ,88, 'None'),
('Electrical Engineering', '21021513' ,'Lại Thị Như Quỳnh', 'Class1', 'Female','nhuquynh@gmail.com', '2002-05-27', 8.5 , 0.0 ,87, 'None')
;

insert into ten-bang (key1, key2, key3) values ('value1','value2','value3')