Base De Datos
madoll9 de Noviembre de 2014
201 Palabras (1 Páginas)165 Visitas
mysql> insert into provedores values('p1','carlos','20','sevilla');
Query OK, 1 row affected (1.79 sec)
mysql> insert into provedores values('p2','juan','10','madrid');
Query OK, 1 row affected (0.01 sec)
mysql> insert into provedores values('p3','jose','30','sevilla');
Query OK, 1 row affected (0.01 sec)
mysql> insert into provedores values('p4','inma','20','sevilla');
Query OK, 1 row affected (0.00 sec)
mysql> insert into provedores values('p5','eva','30','caceres');
Query OK, 1 row affected (0.02 sec)
mysql> insert into envios values('p1','c1','t1','200');
Query OK, 1 row affected (0.28 sec)
mysql> insert into envios values('p1','c1','t1','700');
Query OK, 1 row affected (0.00 sec)
mysql> insert into envios values('p2','c3','p1','400');
Query OK, 1 row affected (0.00 sec)
mysql> insert into envios values('p2','c3','p2','200');
Query OK, 1 row affected (0.00 sec)
mysql> insert into envios values('p2','c2','p3','200');
Query OK, 1 row affected (0.00 sec)
mysql> insert into articulos values('t1','clasificadora','madrid');
Query OK, 1 row affected (0.09 sec)
mysql> insert into articulos values('t2','perforadora','malaga');
Query OK, 1 row affected (0.01 sec)
mysql> insert into articulos values('t3','lectora','caceres');
Query OK, 1 row affected (0.00 sec)
mysql> insert into articulos values('t4','consola','caceres');
Query OK, 1 row affected (0.01 sec)
mysql> insert into articulos values('t5','mezcladora','sevilla');
Query OK, 1 row affected (0.00 sec)
mysql> insert into componentes values('c1','x3a','rojo','12','sevilla');
Query OK, 1 row affected (0.07 sec)
mysql> insert into componentes values('c2','b85','verde','17','madrid');
Query OK, 1 row affected (0.00 sec)
mysql> insert into componentes values('c3','c4b','azul','17','malaga');
Query OK, 1 row affected (0.00 sec)
mysql> insert into componentes values('c4','c4b','rojo','14','sevilla');
Query OK, 1 row affected (0.00 sec)
mysql> insert into componentes values('c5','vt8','azul','12','madrid');
Query OK, 1 row affected (0.01 sec)
...