Taller

mysql> INSERT INTO `exc_empxcom` (`exc_int_cui`,`emp_int_cui`,`com_int_cui`) VAL
UES
-> (653,26,13),
-> (654,12,3),
-> (655,53,5);
Query OK, 3 rows affected (0.03 sec)
Records: 3Duplicates: 0 Warnings: 0

mysql> /*!40000 ALTER TABLE `exc_empxcom` ENABLE KEYS */;
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql>
mysql> /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;Query OK, 0 rows affected (0.00 sec)

mysql> /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
Query OK, 0 rows affected (0.00 sec)

mysql> /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS*/;
Query OK, 0 rows affected (0.00 sec)

mysql> /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
Query OK, 0 rows affected (0.00 sec)

mysql> /*!40101 SETCHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
Query OK, 0 rows affected (0.00 sec)

mysql> /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Query OK, 0 rows affected (0.00 sec)

mysql> /*!40101SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
Query OK, 0 rows affected (0.00 sec)

mysql> use personal_quality;
Database changed
mysql> show tables;
+----------------------------+
|Tables_in_personal_quality |
+----------------------------+
| com_competencias |
| emp_empleados |
| exc_empxcom |
+----------------------------+
3 rows in set(0.02 sec)

mysql> describe emp_empleados;
+-------------------+------------------+------+-----+---------+----------------+

| Field | Type | Null | Key | Default | Extra|

+-------------------+------------------+------+-----+---------+----------------+

| emp_int_cui | int(10) unsigned | NO | PRI | NULL | auto_increment |

| emp_var_nombres| varchar(45) | NO | | NULL | |

| emp_var_apellidos | varchar(45) | NO | | NULL | |

| emp_var_direccion | varchar(45) | NO |...