c9ijppnn

1drop database if exists alumnado;
2create database alumnado;
3use alumnado;
4
5DROP TABLE IF EXISTS comercial;
6CREATE TABLE comercial (
7num_empleado int(11) default 0,
8nombre varchar(30) default NULL,
9apellido varchar(40) default NULL, 
10commision tinyint(4) default NULL, 
11fecha_registro date default NULL, 
12cumpleanios date default NULL ) ENGINE=MyISAM;
13INSERT INTO comercial VALUES (1, 'Ana','Sola','10','2000-02-15','1996-03-18');
14INSERT INTO comercial VALUES (2, 'Elena','Ruiz','15','1998-07-09','1998-11-30');
15INSERT INTO comercial VALUES (3, 'Lola','Lopez','10','2001-05-14','1991-06-18');
16INSERT INTO comercial VALUES (4, 'Zoe','Perez','10','2002-11-23','2002-01-04');
17INSERT INTO comercial VALUES (5, 'Jenny','Morgan','10','2000-02-15','1986-03-18');
18INSERT INTO comercial VALUES (6, 'Juan','Mena','15','1998-07-09','1999-11-30');
19INSERT INTO comercial VALUES (7, 'Miguel','Saenz','10','2001-05-14','1997-06-18');
20INSERT INTO comercial VALUES (8, 'Luis','Garcia','10','2002-11-23','1998-01-04');
21SELECT * FROM comercial;
22DESCRIBE comercial;
23
24DROP TABLE IF EXISTS cliente;
25CREATE TABLE cliente( 
26	id int(11) NOT NULL DEFAULT 0,
27	nombre varchar(30) default NULL, 
28    apellido varchar(40) default NULL,
29    PRIMARY KEY (id)
30) engine=MyISAM;
31INSERT INTO	cliente VALUES	(1,'Zoe','Alvarez');
32INSERT INTO	cliente VALUES	(2,'Jenny', 'Gina');
33INSERT INTO	cliente VALUES	(3,'Hector','Jaro');
34INSERT INTO	cliente VALUES	(4,'Ruben', 'Rio');
35INSERT INTO	cliente VALUES	(5,'Juan','Lima');
36INSERT INTO	cliente VALUES	(6,'Ana', 'Lopez');
37INSERT INTO	cliente VALUES	(7,'Pepe','Sanchez');
38INSERT INTO	cliente VALUES	(8,'Eva', 'Roma');
39SELECT * FROM cliente;
40DESCRIBE cliente;
41SHOW INDEX FROM cliente IN alumnado;
42
43DROP TABLE IF EXISTS ventas;
44CREATE TABLE ventas ( 
45	codigo int(11) default 0 NOT NULL PRIMARY KEY, 
46    comercial int(11) default NULL, 
47    id int(11) default NULL, 
48    valor int(11) default NULL
49) engine=MyISAM;
50INSERT INTO ventas VALUES (1, 1, 1, 2000);
51INSERT INTO ventas VALUES (2, 4, 3, 250);
52INSERT INTO	ventas VALUES (3, 2, 3, 500);
53INSERT INTO	ventas VALUES (4, 1, 4, 450);
54INSERT INTO	ventas VALUES (5, 3, 1, 3800);
55INSERT INTO	ventas VALUES (6, 1, 2, 500);
56INSERT INTO	ventas VALUES (7, 2, NULL, 670);
57INSERT INTO	ventas VALUES (8, 3, 3, 1000);
58SELECT * FROM ventas;
59DESCRIBE ventas;