BASE DE DATOS

Axel Alejandro Preciado Ruvalcaba 283002
mysql> insert into Puesto values(01,'Administrador',2000);
Query OK, 1 row affected (0.02 sec)

mysql> insert into Puesto values(02,'Computacion',3000);
Query OK, 1 row affected (0.03 sec)

mysql> insert into Puesto values(03,'Gerente',2500);
Query OK, 1 row affected (0.03 sec)

mysql> insert into Puesto values(04,'Contador',2000);
Query OK, 1row affected (0.03 sec)

mysql> insert into Puesto values(04,'Secretaria',1000);
ERROR 1062 (23000): Duplicate entry '4' for key 1
mysql> insert into Puesto values(05,'Secretaria',1000);
Query OK, 1 row affected (0.03 sec)

mysql> select *from Puesto;
+-----------+---------------+---------+
| id_puesto | nombreP | salario |
+-----------+---------------+---------+
| 1 |Administrador | 2000 |
| 2 | Computacion | 3000 |
| 3 | Gerente | 2500 |
| 4 | Contador | 2000 |
| 5 | Secretaria | 1000 |
+-----------+---------------+---------+
5 rows in set (0.02 sec)

mysql> insert into Localidad values(01,'Insurgentes',20,'Tijuana',BC);
ERROR 1054 (42S22): Unknown column 'BC' in 'field list'
mysql>insert into Localidad values(01,'Insurgentes',20,'Tijuana','BC');
Query OK, 1 row affected (0.03 sec)

mysql> insert into Localidad values(02,'Centro',15,'Rosarito','BC');
Query OK, 1 row affected (0.03 sec)

mysql> insert into Localidad values(02,'Revolucion',15,'Tecate','BC');
ERROR 1062 (23000): Duplicate entry '2' for key 1
mysql> insert into Localidadvalues(03,'Revolucion',15,'Tecate','BC');
Query OK, 1 row affected (0.03 sec)

mysql> insert into Localidad values(04,'Pinos',7,'Ensenada','BC');
Query OK, 1 row affected (0.03 sec)

mysql> insert into Localidad values(05,'Hongo',35,'Mexicali','BC');
Query OK, 1 row affected (0.02 sec)

mysql> select *from Localidad;
+--------------+-------------+--------+----------+--------+
| id_localidad | direccion | numero | ciudad| estado |
+--------------+-------------+--------+----------+--------+
| 1 | Insurgentes | 20 | Tijuana | BC |
| 2 | Centro | 15 | Rosarito | BC |
| 3 | Revolucion | 15 | Tecate | BC |
| 4 | Pinos | 7 | Ensenada | BC |
| 5 | Hongo | 35 | Mexicali | BC |+--------------+-------------+--------+----------+--------+
5 rows in set (0.04 sec)

mysql> LOAD DATA LOCAL INFILE 'c:/mysql/nombrep9.txt' INTO TABLE nombre
-> ;
ERROR 2 (HY000): File 'c:\mysql\nombrep9.txt' not found (Errcode: 2)
mysql> LOAD DATA LOCAL INFILE 'c:/mysql/nombrep9.txt' INTO TABLE nombre;
ERROR 2 (HY000): File 'c:\mysql\nombrep9.txt' not found (Errcode: 2)
mysql> exit;


mysql>LOAD DATA LOCAL INFILE 'c:/mysql/nombresP9.txt' INTO TABLE nombre;
Query OK, 14 rows affected (0.05 sec)
Records: 15 Deleted: 0 Skipped: 1 Warnings: 0

mysql> select *from nombre;
+-----------+-----------+-----------+------------+
| nombre | apellidoP | apellidoM | otroN |
+-----------+-----------+-----------+------------+
| Alejandro | Tellez | Figueroa | David
|
|Andrea | Tellez | Arzola | -
|
| Axel | Preciado | Ruvalcaba | Alejandro
|
| Dario | Preciado | Ochoa | Alejandro
|
| Eduardo | Quintanar | Gomez | -
|
| Fabian | Zaragoza | Solis | -
|
| Javier | Hernandez | Hernandez | -
|
| Jose | Lopez | Perez | -
|
| Juan | Jimenez | Perez| Jose
|
| Luis | Quintana | Magana | -
|
| Miguel | Gonzalez | Narvaes | Angel
|
| Nataly | Preciado | Ruvalcaba | Alejandra
|
| Pepe | Martinez | Martinez | -
|
| Samuel | Preciado | Ruvalcaba | Alejandro
|
+-----------+-----------+-----------+------------+
14 rows in set (0.20 sec)

mysql> select *from nombre;...