PRACTICA 1(EJEMPLOS)

Enter password: ***

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 8

Server version: 5.0.51b-community-nt-log MySQL Community Edition (GPL)

 

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

 

mysql> use prueba1;

Database changed

mysql> select * from empleados;

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

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

| num_emp | nombre    | ape_pate | ape_mate  | oficio     | fecha_alta | salario

 | comision |

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

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

|     136 | guadalupe | delgado  | carrillo  | estudiante | 2012-11-05 |     569

 |      100 |

|     137 | amanda    | garcia   | fuentes   | estudiante | 2011-01-15 |     870

 |       10 |

|     150 | edgar     | lucio    | rodriguez | estudia    | 2007-12-10 |     820

 |       18 |

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

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

3 rows in set (0.00 sec)

 

mysql> select * from empleados;

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

| num_emp | nombre    | ape_pate | ape_mate  | oficio     | fecha_alta | salario | comision |

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

|     136 | guadalupe | delgado  | carrillo  | estudiante | 2012-11-05 |     569 |      100 |

|     137 | amanda    | garcia   | fuentes   | estudiante | 2011-01-15 |     870 |       10 |

|     150 | edgar     | lucio    | rodriguez | estudia    | 2007-12-10 |     820 |       18 |

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

3 rows in set (0.00 sec)

mysql>