ACTIVIDAD #18

Implementar el esquema de base de datos de la clínica veterinaria (incluir todas las tablas  y  datos de 5 pacientes con 2  registros de  visita a la clínica cada  uno) 

Microsoft Windows [Versión 6.1.7601]

Copyright (c) 2009 Microsoft Corporation. Reservados todos los derechos.

C:\Users\Chiquita>cd..

C:\Users>cd..

C:\>cd xampp

C:\xampp>cd mysql

C:\xampp\mysql>cd bin

C:\xampp\mysql\bin>mysql -hlocalhost -uroot -p

Enter password:

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

Your MySQL connection id is 1

Server version: 5.5.16 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 VETERINARIA;

Database changed

mysql> CREATE TABLE PROPIETARIO(Id_PROPIETARIO INT NULL PRIMARY KEY,

NOMBRE VARCHAR(20),

DIRECCION VARCHAR(20),

TELEFONO VARCHAR(10),

PROFECCION VARCHAR(20));

Query OK, 0 rows affected (1.16 sec)

mysql> INSERT INTO PROPIETARIO (Id_PROPIETARIO,NOMBRE,DIRECCION,TELEFONO,PROFECCION) VALUES (1234,'LEONARDO PEREZ','MEJIA 2030','6566305622','ING. INDUSTRIAL');

Query OK, 1 rowaffected (0.25 sec)

mysql> INSERT INTO PROPIETARIO Id_PROPIETARIO,NOMBRE,DIRECCION,TELEFONO,PROFECCION) VALUES (1235,'ANTONIO LOPEZ','LA TULE 270','6566302980','ING. CIVIL'),

-> (1236,'MARCO BARRAZA','ROSALES 483','6566920343','DENTISTA'),

-> (1237,'DANIEL DELGADO','DE LEON 3920-20','6562391038','CIRUJANO');

Query OK, 3 rows affected (0.71 sec)

Records: 3  Duplicates: 0  Warnings: 0

mysql> INSERT PROPIETARIO VALUES(1238,'MARIO NAVA','PORTAL TRIUNFO','6561709602'

,'ING. INDUSTRIAL');

Query OK, 1 row affected (0.29 sec)

mysql> INSERT INTO CONSULTA VALUES(0001,'VACUNA','23/09/2011',NULL,NULL);

Query OK, 1 row affected, 1 warning (0.21 sec)

mysql> INSERT INTO CONSULTA VALUES(0002,'ANTIRIAVICO','23/10/2012',NULL,NULL);

Query OK, 1 row affected, 1 warning (0.04 sec)

mysql> INSERT INTO CONSULTA VALUES(0003,'ANTIRIAVICO','30/10/2012',NULL,NULL);

Query OK, 1 row affected, 1 warning (0.08 sec)

mysql> INSERT INTO CONSULTA VALUES(0004,'ANTIRIAVICO','30/12/2012',NULL,NULL);

Query OK, 1 row affected, 1 warning (0.07 sec)

mysql> INSERT INTO CONSULTA VALUES(0005,'CHEQUEO','30/12/2012',NULL,NULL);

Query OK, 1 row affected, 1 warning (0.09 sec)