Permalink
Cannot retrieve contributors at this time
Name already in use
A tag already exists with the provided branch name. Many Git commands accept both tag and branch names, so creating this branch may cause unexpected behavior. Are you sure you want to create this branch?
Scripts-SQL-teoria/populate.sql
Go to fileThis commit does not belong to any branch on this repository, and may belong to a fork outside of the repository.
44 lines (40 sloc)
2.23 KB
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* Inserción de datos de Departments */ | |
/* Valores correctos */ | |
INSERT INTO Departments (nameDep, city) VALUES ('Historia', NULL); | |
INSERT INTO Departments (nameDep, city) VALUES ('Informática', 'Sevilla'); | |
INSERT INTO Departments (nameDep, city) VALUES ('Arte', 'Cádiz'); | |
/* Otros valores, descomente el código para ver el resultado */ | |
/* INSERT INTO Departments (nameDep, city) VALUES ('Historia', NULL);*/ | |
/* INSERT INTO Departments (nameDep, city) VALUES ('Informática', 'Sevilla'); */ | |
/* Inserción de datos de Empleados */ | |
/* Valores correctos */ | |
/* Pedro de Historia */ | |
INSERT INTO Employees(departmentId, bossId, nameEmp, salary, startDate, endDate, fee) | |
VALUES (1, NULL, 'Pedro', 2300.00, '2017-09-15', NULL, 0.2); | |
/* José de Historia*/ | |
INSERT INTO Employees(departmentId, bossId, nameEmp, salary, startDate, endDate, fee) | |
VALUES (1, NULL, 'José', 2500.00, '2018-08-15', NULL, 0.5); | |
/* Lola de Informática */ | |
INSERT INTO Employees(departmentId, bossId, nameEmp, salary, startDate, endDate, fee) | |
VALUES (2, NULL, 'Lola', 2300.00, '2018-08-15', NULL, 0.3); | |
/* Luis trabajó para Pedro 3 meses */ | |
INSERT INTO Employees(departmentId, bossId, nameEmp, salary, startDate, endDate, fee) | |
VALUES (1, 1, 'Luis', 1300.00, '2018-08-15', '2018-11-15', 0); | |
/* Ana trabajó para Pedro 3 meses */ | |
INSERT INTO Employees(departmentId, bossId, nameEmp, salary, startDate, endDate, fee) | |
VALUES (1, 1, 'Ana', 1300.00, '2018-08-15', '2018-11-15', 0); | |
/* Otros valores, descomente el código para ver el resultado */ | |
/* Manuel de Electrónica */ | |
/* INSERT INTO Employees(departmentId, bossId, nameEmp, salary, startDate, endDate, fee) | |
VALUES (5, null, 'Manuel', 2300.00, '2017-08-15', NULL, 0.6); | |
/* Francisco trabajo para Yolanda */ | |
/* INSERT INTO Employees(departmentId, bossId, nameEmp, salary, startDate, endDate, fee) | |
VALUES (1, 23, 'Francisco', 1300.00, '2017-08-15', '2017-11-15', 0); | |
*/ | |
/* Subir el sueldo de Pedro */ | |
-- UPDATE Employees SET salary='2500.00' WHERE employeeId=1; | |
/* Despedir a José */ | |
-- UPDATE Employees SET fechaFinal='2019-08-15' WHERE employeeId=2; | |
/* Borrar departamento de Historia, descomente el código para ver el resultado */ | |
/* DELETE FROM Departments WHERE departmentId=1; */ | |
-- UPDATE Employees SET departmentId=NULL WHERE employeeId=5; |