Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Practica2
show databases; use rextester; show tables; create table AlumnosCona (id int, Nombre varchar(30), Edad int); Mysql> USE Practicas; Databases changed Mysql> mysql>CREATE TABLE Empleados(Emp_No int(4), Apellido varchar(10), Oficio varchar(15), Fecha_Alt Date, Salario int(7), Comision int(7), Dept_No int(7)); Mysql>DESCRIBE Empleados; podemos verificar la estructura de la tabla recién creada. Mysql>INSERT INTO Empleados VALUES (1, ‘Torres’,’Carpintero’, ‘01/05/1990’, 1500, 150, 1); Query ok, 1 row affect (0.05 sec) Mysql>INSERT INTO Empleados VALUES (2, 'Jimenez','Arquitecto','20/12/1991', 7500, 750, 2); Query ok, 1 row affect (0.05 sec) Mysql>INSERT INTO Empleados VALUES (3, 'Ruiz','Programador', '15/06/2000', 4000, 400, 3); Query ok, 1 row affect (0.05 sec) Mysql>INSERT INTO Empleados VALUES (4, 'Gutierrez','Albañil', '23/11/1995', 1000, 100, 4); Query ok, 1 row affect (0.05 sec) Mysql>INSERT INTO Empleados VALUES (5, 'Flores','Pintor', '19/04/1992', 1500, 150, 5); Query ok, 1 row affect (0.05 sec) Mysql>INSERT INTO Empleados VALUES (6, 'Duran','Carpintero', '30/10/2001', 1500, 150, 1) Query ok, 1 row affect (0.05 sec) Mysql>INSERT INTO Empleados VALUES (7, 'Perez','Ing civil', '07/12/1990', 3500, 350, 2); Query ok, 1 row affect (0.05 sec) Mysql>INSERT INTO Empleados VALUES (8, 'Lozano','Arquitecto', '09/02/1995', 7500, 750, 2); Query ok, 1 row affect (0.05 sec) Mysql>INSERT INTO Empleados VALUES (9, 'Marquez','Carpintero', '01/05/1990', 1500, 150, 1); Query ok, 1 row affect (0.05 sec) Mysql>INSERT INTO Empleados VALUES (10, 'Blanco','Pintor', '01/05/1990', 1500, 150, 5); Query ok, 1 row affect (0.05 sec) Mysql>
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
kuy09:admin@pkms99.info
MySQL: comparison including "IS NULL" cases
proyecto
Simon_Test1
Test for MySQL "serializable" transaction, part 1
Funciones suma fechas MySQL
My mysql code - sunil
Comparación de Collations general-spanish-latin en MySQL
Srinivas
Siva7
Please log in to post a comment.