mysql> create database Veterinaria;
Query OK, 1 row affected (0.03 sec)
mysql> use Veterinaria;
Database changed
mysql> Create table mascota (id_M varchar (10),Nombre_M varchar (20), Sexo_M var
char (2), FechaNacimientos_M date, Especie_M varchar (25), peso_M varchar (5), R
aza_M varchar (20), Alzada_M varchar (20));
Query OK, 0 rows affected (0.08 sec)
mysql> insert into mascota values ('0001','Cosita', 'f', '2010-02-28','Mamifero'
,'4','pudul', '10 mts');
Query OK, 1 row affected (0.02 sec)
mysql> insert into mascota values ('0002','Shastar', 'M', '2010-05-20','Mamifero
','4','Husky', '3 mts');
Query OK, 1 row affected (0.00 sec)
mysql> insert into mascota values ('0003','Roky', 'M', '2011-04-21','Mamifero','
3','Boxer', '7 mts');
Query OK, 1 row affected (0.00 sec)
mysql> insert into mascota values ('0004','Scam', 'M', '2001-07-11','Reptil','1'
,'Serpiente', '7 mts');
Query OK, 1 row affected (0.00 sec)
mysql> insert into mascota values ('0005','Saltadora', 'F', '2013-01-17','Anfibi
os','2','Rana', '1 mts');
Query OK, 1 row affected (0.00 sec)
mysql> describe mascota;
+--------------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------------+-------------+------+-----+---------+-------+
| id_M | varchar(10) | YES | | NULL | |
| Nombre_M | varchar(20) | YES | | NULL | |
| Sexo_M | varchar(2) | YES | | NULL | |
| FechaNacimientos_M | date | YES | | NULL | |
| Especie_M | varchar(25) | YES | | NULL | |
| peso_M | varchar(5) | YES | | NULL | |
| Raza_M | varchar(20) | YES | | NULL | |
| Alzada_M | varchar(20) | YES | | NULL | |
+--------------------+-------------+------+-----+---------+-------+
8 rows in set (0.04 sec)
mysql> select * from mascota;
+------+-----------+--------+--------------------+-----------+--------+---------
--+----------+
| id_M | Nombre_M | Sexo_M | FechaNacimientos_M | Especie_M | peso_M | Raza_M
| Alzada_M |
+------+-----------+--------+--------------------+-----------+--------+---------
--+----------+
| 0001 | Cosita | f | 2010-02-28 | Mamifero | 4 | pudul
| 10 mts |
| 0002 | Shastar | M | 2010-05-20 | Mamifero | 4 | Husky
| 3 mts |
| 0003 | Roky | M | 2011-04-21 | Mamifero | 3 | Boxer
| 7 mts |
| 0004 | Scam | M | 2001-07-11 | Reptil | 1 | Serpient
e | 7 mts |
| 0005 | Saltadora | F | 2013-01-17 | Anfibios | 2 | Rana
| 1 mts |
+------+-----------+--------+--------------------+-----------+--------+---------
--+----------+
5 rows in set (0.00 sec)
mysql> alter table mascota modify id_M varchar (10) primary key;
Query OK, 5 rows affected (0.05 sec)
Records: 5 Duplicates: 0 Warnings: 0
mysql> describe mascota;
+--------------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------------+-------------+------+-----+---------+-------+
| id_M | varchar(10) | NO | PRI | NULL | |
| Nombre_M | varchar(20) | YES | | NULL | |
| Sexo_M | varchar(2) | YES | | NULL | |
| FechaNacimientos_M | date | YES | | NULL | |
| Especie_M | varchar(25) | YES | | NULL | |
| peso_M | varchar(5) | YES | | NULL | |
| Raza_M | varchar(20) | YES | | NULL | |
| Alzada_M | varchar(20) | YES | | NULL | |
+--------------------+-------------+------+-----+---------+-------+
8 rows in set (0.01 sec)
mysql> Create table propietario (id_p varchar (10),Nombre_p varchar (20), Prof_O
ficio_p varchar (25), Direccion_p date, telefono_p varchar (25));
Query OK, 0 rows affected (0.05 sec)mysql> insert into propietario values ('1000','Ruben', 'Empleado', 'Misiones ','
6563739115');
Query OK, 1 row affected, 1 warning (0.00 sec)
mysql> insert into propietario values ('1001','Alejandra', 'Hogar', 'Division de
l norte ','6562815698');
Query OK, 1 row affected, 1 warning (0.00 sec)
mysql> insert into propietario values ('1002','Angel', 'Maestro', 'Nueva Espana'
,'6562963587');
Query OK, 1 row affected, 1 warning (0.00 sec)
mysql> insert into propietario values ('1003','Angelica', 'Maestra', 'Tierra y L
ibertad','6563659874');
Query OK, 1 row affected, 1 warning (0.00 sec)
mysql> select * from propietario;
+------+-----------+---------------+-------------+------------+
| id_p | Nombre_p | Prof_Oficio_p | Direccion_p | telefono_p |
+------+-----------+---------------+-------------+------------+
| 1000 | Ruben | Empleado | 0000-00-00 | 6563739115 |
| 1001 | Alejandra | Hogar | 0000-00-00 | 6562815698 |
| 1002 | Angel | Maestro | 0000-00-00 | 6562963587 |
| 1003 | Angelica | Maestra | 0000-00-00 | 6563659874 |
+------+-----------+---------------+-------------+------------+
4 rows in set (0.00 sec)
mysql> Create table Caracteristicas (Condicion varchar (10), Pelaje varchar (20)
, Tatuajes varchar (25), Cicatrices varchar(5), FinZootecnico varchar (25), Cir
ujias varchar (20), Color varchar (20));
Query OK, 0 rows affected (0.03 sec)
mysql> describe caracteristicas;
+---------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+-------------+------+-----+---------+-------+
| Condicion | varchar(10) | YES | | NULL | |
| Pelaje | varchar(20) | YES | | NULL | |
| Tatuajes | varchar(25) | YES | | NULL | |
| Cicatrices | varchar(5) | YES | | NULL | |
| FinZootecnico | varchar(25) | YES | | NULL | |
| Cirujias | varchar(20) | YES | | NULL | |
| Color | varchar(20) | YES | | NULL | |
+---------------+-------------+------+-----+---------+-------+
7 rows in set (0.01 sec)
mysql>
Microsoft Windows [Versión 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. Reservados todos los derechos.
C:\Users\prueba>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.1.41 Source distribution
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> use veterinaria;
Database changed
mysql> describe caracteristicas;
+---------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+-------------+------+-----+---------+-------+
| Condicion | varchar(10) | YES | | NULL | |
| Pelaje | varchar(20) | YES | | NULL | |
| Tatuajes | varchar(25) | YES | | NULL | |
| Cicatrices | varchar(5) | YES | | NULL | |
| FinZootecnico | varchar(25) | YES | | NULL | |
| Cirujias | varchar(20) | YES | | NULL | |
| Color | varchar(20) | YES | | NULL | |
+---------------+-------------+------+-----+---------+-------+
7 rows in set (0.03 sec)
mysql> insert into caracteristicas values ('estable','sedoso','no','no','mascota
','no','cafe');
Query OK, 1 row affected (0.03 sec)
mysql> insert into caracteristicas values ('Regular','maltratado','no','si','mas
cota','no','blanco');
Query OK, 1 row affected (0.00 sec)
mysql> insert into caracteristicas values ('buena','grasoso','si','no','trabajo'
,'si','negro');
Query OK, 1 row affected (0.00 sec)
mysql> insert into caracteristicas values ('mala','sedoso','si','si','trabajo','
no','gris');
Query OK, 1 row affected (0.00 sec)
mysql> insert into caracteristicas values ('Regular','maltratado','no','no','mas
cota','si','cafe claro');
Query OK, 1 row affected (0.00 sec)
mysql> select * from caracteristicas;
+-----------+------------+----------+------------+---------------+----------+---
---------+
| Condicion | Pelaje | Tatuajes | Cicatrices | FinZootecnico | Cirujias | Co
lor |
+-----------+------------+----------+------------+---------------+----------+---
---------+
| estable | sedoso | no | no | mascota | no | ca
fe |
| Regular | maltratado | no | si | mascota | no | bl
anco |
| buena | grasoso | si | no | trabajo | si | ne
gro |
| mala | sedoso | si | si | trabajo | no | gr
is |
| Regular | maltratado | no | no | mascota | si | ca
fe claro |
+-----------+------------+----------+------------+---------------+----------+---
---------+
5 rows in set (0.00 sec)
mysql> alter table propietario add id_M varchar (10);
Query OK, 4 rows affected (0.07 sec)
Records: 4 Duplicates: 0 Warnings: 0
mysql> alter table propietario add foreign key (id_M) references mascota (id_M)
;
Query OK, 4 rows affected (0.05 sec)
Records: 4 Duplicates: 0 Warnings: 0
mysql> alter table caracteristicas add foreign key (id_M) references mascota (i
d_M);
ERROR 1072 (42000): Key column 'id_M' doesn't exist in table
mysql> alter table caracteristicas add id_M varchar (10);
Query OK, 5 rows affected (0.04 sec)
Records: 5 Duplicates: 0 Warnings: 0
mysql> alter table caracteristicas add foreign key (id_M) references mascota (i
d_M);
Query OK, 5 rows affected (0.04 sec)
Records: 5 Duplicates: 0 Warnings: 0
mysql> select * from mascota join propietario;
+------+-----------+--------+--------------------+-----------+--------+---------
--+----------+------+-----------+---------------+-------------+------------+----
--+
| id_M | Nombre_M | Sexo_M | FechaNacimientos_M | Especie_M | peso_M | Raza_M
| Alzada_M | id_p | Nombre_p | Prof_Oficio_p | Direccion_p | telefono_p | id_
M |
+------+-----------+--------+--------------------+-----------+--------+---------
--+----------+------+-----------+---------------+-------------+------------+----
--+
| 0001 | Cosita | f | 2010-02-28 | Mamifero | 4 | pudul
| 10 mts | 1000 | Ruben | Empleado | 0000-00-00 | 6563739115 | NUL
L |
| 0001 | Cosita | f | 2010-02-28 | Mamifero | 4 | pudul
| 10 mts | 1001 | Alejandra | Hogar | 0000-00-00 | 6562815698 | NUL
L |
| 0001 | Cosita | f | 2010-02-28 | Mamifero | 4 | pudul
| 10 mts | 1002 | Angel | Maestro | 0000-00-00 | 6562963587 | NUL
L |
| 0001 | Cosita | f | 2010-02-28 | Mamifero | 4 | pudul
| 10 mts | 1003 | Angelica | Maestra | 0000-00-00 | 6563659874 | NUL
L |
| 0002 | Shastar | M | 2010-05-20 | Mamifero | 4 | Husky
| 3 mts | 1000 | Ruben | Empleado | 0000-00-00 | 6563739115 | NUL
L |
| 0002 | Shastar | M | 2010-05-20 | Mamifero | 4 | Husky
| 3 mts | 1001 | Alejandra | Hogar | 0000-00-00 | 6562815698 | NUL
L |
| 0002 | Shastar | M | 2010-05-20 | Mamifero | 4 | Husky
| 3 mts | 1002 | Angel | Maestro | 0000-00-00 | 6562963587 | NUL
L |
| 0002 | Shastar | M | 2010-05-20 | Mamifero | 4 | Husky
| 3 mts | 1003 | Angelica | Maestra | 0000-00-00 | 6563659874 | NUL
L |
| 0003 | Roky | M | 2011-04-21 | Mamifero | 3 | Boxer
| 7 mts | 1000 | Ruben | Empleado | 0000-00-00 | 6563739115 | NUL
L |
| 0003 | Roky | M | 2011-04-21 | Mamifero | 3 | Boxer
| 7 mts | 1001 | Alejandra | Hogar | 0000-00-00 | 6562815698 | NUL
L |
| 0003 | Roky | M | 2011-04-21 | Mamifero | 3 | Boxer
| 7 mts | 1002 | Angel | Maestro | 0000-00-00 | 6562963587 | NUL
L |
| 0003 | Roky | M | 2011-04-21 | Mamifero | 3 | Boxer
| 7 mts | 1003 | Angelica | Maestra | 0000-00-00 | 6563659874 | NUL
L |
| 0004 | Scam | M | 2001-07-11 | Reptil | 1 | Serpient
e | 7 mts | 1000 | Ruben | Empleado | 0000-00-00 | 6563739115 | NUL
L |
| 0004 | Scam | M | 2001-07-11 | Reptil | 1 | Serpient
e | 7 mts | 1001 | Alejandra | Hogar | 0000-00-00 | 6562815698 | NUL
L |
| 0004 | Scam | M | 2001-07-11 | Reptil | 1 | Serpient
e | 7 mts | 1002 | Angel | Maestro | 0000-00-00 | 6562963587 | NUL
L |
| 0004 | Scam | M | 2001-07-11 | Reptil | 1 | Serpient
e | 7 mts | 1003 | Angelica | Maestra | 0000-00-00 | 6563659874 | NUL
L |
| 0005 | Saltadora | F | 2013-01-17 | Anfibios | 2 | Rana
| 1 mts | 1000 | Ruben | Empleado | 0000-00-00 | 6563739115 | NUL
L |
| 0005 | Saltadora | F | 2013-01-17 | Anfibios | 2 | Rana
| 1 mts | 1001 | Alejandra | Hogar | 0000-00-00 | 6562815698 | NUL
L |
| 0005 | Saltadora | F | 2013-01-17 | Anfibios | 2 | Rana
| 1 mts | 1002 | Angel | Maestro | 0000-00-00 | 6562963587 | NUL
L |
| 0005 | Saltadora | F | 2013-01-17 | Anfibios | 2 | Rana
| 1 mts | 1003 | Angelica | Maestra | 0000-00-00 | 6563659874 | NUL
L |
+------+-----------+--------+--------------------+-----------+--------+---------
--+----------+------+-----------+---------------+-------------+------------+----
--+
20 rows in set (0.01 sec)
mysql>
No hay comentarios:
Publicar un comentario