Actividad 18

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

Your MySQL connection id is 4

Server version: 5.5.27 MySQL Community Server (GPL)

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use veterin;

Database changed

mysql> select*from clientes;

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

| NCliente | nombreCliente    | direccion            | tel         | oficio       |

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

|          2 | Ricardo Alvarez | Nigeria #7610         | 6370147  | Estudiante    |

|          3 | Nohemy Mata      | Limonero #3415       | 6151990  | Estudiante |

|          1 | Alexa Carlos    | Miravalle #8457 | 6195099  | Estudiante  |

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

3 rows in set (0.21 sec)

mysql> insert into clientes values(04,'Melissa Varela','Marquez #4290','6891254','Estudiante');

Query OK, 1 row affected (0.01 sec)

mysql> insert into clientes values(05,'Karely Alvarez','Nigeria #7610','6370147','Estudiante');

Query OK, 1 row affected (0.01 sec)

mysql> select*from clientes;

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

| NCliente | nombreCliente    | direccion            | tel         | oficio       |

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

|          2 | Ricardo Alvarez | Nigeria #7610         | 6370147  | Estudiante    |

|          3 | Nohemy Mata      | Limonero #3415       | 6151990  | Estudiante |

|          1 | Alexa Carlos    | Miravalle #8457 | 6195099  | Estudiante  |

|          4 | Melissa Varela  | Marquez #4290     | 6891254  | Estudiante    |

|          5 | Karely Alvarez | Nigeria #7610      | 6370147  | Estudiante    |

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

5 rows in set (0.01 sec)

mysql> select*from mascota;

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

| NumP | nombre | peso | sexo | raza         | FechaNacimiento |

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

|    1 | Princess  |  0.5 | H    | Chihuahua      | 20-02-2010  |

|    2 | Negro | 15.5 | M    | Callejero | 12-03-2009  |

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

2 rows in set (0.15 sec)

mysql> insert into mascota values(003,'Jerry',10,'M','Pastor','13-02-2010');

Query OK, 1 row affected (0.00 sec)

mysql> insert into mascota values(004,'Bamby',6,'M','Callejero','11-05-2001');

Query OK, 1 row affected (0.00 sec)

mysql> insert into mascota values(005,'Canela',7,'H','Pastor ','02-01-2013');

Query OK, 1 row affected (0.00 sec)

mysql> select*from mascota;

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

| NumP | nombre | peso | sexo | raza         | FechaNacimiento |

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

|    1 | Princess  |  0.5 | H    | Chihuahua      | 20-02-2010  |

|    2 | Negro | 15.5 | M    | Callejero | 12-03-2009  |

|    3 | Jerry  |   10 | M    | Pastor       | 13-02-2010  |

|    4 | Bamby  |    6 | M    | Callejero      | 11-05-2001  |

|    5 | Canela |  7 | H   | Pastor  | 02-01-2013  |

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

5 rows in set (0.00 sec)

mysql> show tables;

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

| Tables_in_veterin |

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

| antenfermedades   |

| caracteristicas   |

| clientes          |

| direccion         |

| hmedica           |

| info              |

| mascota           |

| mconsulta         |

| servicios         |

| veterinaria       |

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

10 rows in set (0.71 sec)

mysql> exit