mysql base de datos relacionadas

Microsoft Windows [Version 6.0.6001]
Copyright (c) 2006 Microsoft Corporation.  All rights reserved.
C:\Users\familia leyva>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:
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
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> create database veterinaria;
Query OK, 1 row affected (0.02 sec)
mysql> use veterinaria
Database changed
mysql> create tabla datos_perro;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'tabla
 datos_perro' at line 1
mysql> create table datos-perro;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '-perr
o' at line 1
mysql> create tabla datos_perro(ID varchar(15),nombre varchar(30),sexo varchar(1
0),fecha_nacimiento varchar(15),especie varchar(20),peso varchar(15),raza varcha
r(30),alzada varchar (30));
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'tabla
 datos_perro(ID varchar(15),nombre varchar(30),sexo varchar(10),fecha_nacim' at
line 1
mysql> create table datos_perro(ID varchar(15),nombre varchar(30),sexo varchar(1
0),fecha_nacimiento varchar(15),especie varchar(20),peso varchar(15),raza varcha
r(30),alzada varchar (30));
Query OK, 0 rows affected (0.16 sec)
mysql> insert into datos_perro values(0001,'rufi',macho,'2003','null','50 k
g','boxer','null');
Query OK, 1 row affected, 1 warning (0.00 sec)
mysql> insert into datos_perro values(0002,'chester',macho,'2005','null','40 k
g','dalmata','null');
Query OK, 1 row affected, 1 warning (0.00 sec)
mysql> create table datos_propietario(ID varchar(20),nombre varchar (30),profesi
on varchar(30),direccion varchar (30),telefono varchar(15));
Query OK, 0 rows affected (0.14 sec)
mysql> insert into datos_propietario values(0010,'janeth','ingeniera','av tec','
6562950481');
Query OK, 1 row affected, 1 warning (0.00 sec)
mysql> insert into datos_propietario values(0011,'brenda','ingeniera','av de la
raza','6562769420');
Query OK, 1 row affected, 1 warning (0.00 sec)
mysql> create table datos_medio(entorno varchar(40),nutricion varchar (40),estil
o_de_vida varchar(40));
Query OK, 0 rows affected (0.19 sec)
mysql> insert into datos_medio values('patio','croquetas','domestico');
Query OK, 1 row affected, 1 warning (0.00 sec)
mysql> create table constantes_fisiologicas(temperatura varchar (20),frecuencia_
cardiaca varchar(40),pulso varchar(30));
Query OK, 0 rows affected (0.22 sec)
mysql> create table analisis_sistema(piel_y_anexos varchar(40),lesiones_y_anexos
 varchar(40),descripcion_de_las_lesiones_linfonodos varchar(40),musculoso_esquel
etico varchar (40),nervioso varchar(40),otros varchar(40),respiratorio varchar(4
0),genital varchar (40),urinario varchar (40),respiratorio varchar(40),cardiovas
cular varchar (40),digestivo varchar(40),signos_digestivos varchar(40),organos_d
e_los_sentidos varchar(40));
ERROR 1060 (42S21): Duplicate column name 'respiratorio'
mysql>
mysql> create table analisis_sistema(piel_y_anexos varchar(40),lesiones_y_anexos
 varchar(40),descripcion_de_las_lesiones_linfonodos varchar(40),musculoso_esquel
etico varchar (40),nervioso varchar(40),otros varchar(40),sist_resp varchar(40),
genital varchar (40),urinario varchar (40),respiratorio varchar(40),cardiovascul
ar varchar (40),digestivo varchar(40),signos_digestivos varchar(40),organos_de_l
os_sentidos varchar(40));
Query OK, 0 rows affected (0.14 sec)
mysql> create table sistema_musculoso(inspeccion varchar(40),palpacion varchar(2
0),pruebas_especificas varchar(40))2003;
Query OK, 0 rows affected (0.16 sec)
mysql> create table sistema_nervioso(pares_craneales varchar(40),reflejos_postul
ares varchar(40),estado_mental varchar(40),reacciones_postulares varchar(40));
Query OK, 0 rows affected (0.14 sec)
mysql> create table sistema_respiratorio(vias_aereas varchar(40),sonidos_respira
torios varchar(40),patrones_resp varchar(40),sintomas varchar(40));
Query OK, 0 rows affected (0.14 sec)
mysql> create table sistema_cardiovascular(membranas_mucosas varchar(40),caracte
risticas_pulso varchar(40),region_precordial varchar(40),auscultacion varchar(40
),otros varchar (40));
Query OK, 0 rows affected (0.20 sec)
mysql> select *from datos_perro;
+------------+-------+-------+----------------+----------------+---------+
| ID         |nombre | sexo  |fecha_nacimiento|  peso          | raza    |
+------------+-------+-------+----------------+----------------+---------+
|          1 | rufi  | macho | 2003           | 50k            | boxer   |
|          2 |chester| macho | 2005           | 40k            | dalmata |
+------------+-------+-------+----------------+----------------+---------+
3 rows in set (0.00 sec)
mysql> select *datos_propietario;
+------------+-------+-------------+--------------+----------------+
| ID         | nombre| profeccion  |direccion     | telefono       |
+------------+-------+-------------+--------------+----------------+
|          10| janeth| ingeniera   | av tec       | 6562950481     |
|          11| brenda| ingeniera   | av raza      | 6562769420     |
+------------+-------+-------------+--------------+----------------+
3 rows in set (0.00 sec)
mysql> alter table datos_propietario add foreign key (ID) references datos_perro(ID);
Query OK, 3 rows affected (0.07 sec)
Records: 3  Duplicates: 0  Warnings: 0

mysql> select mascota.nombrem,cliente.nombre from mascota,cliente where cliente.
numcliente=mascota.numcliente;
+---------+------------+
| nombre  | nombre     |
+---------+------------+
| rufi    | janeth     |
| chester | brenda     |
+---------+------------+
3 rows in set (0.00 sec)
mysql>