Actividad 18
Type 'help;' or '\h' for
help. Type '\c' to clear the current input statement.
mysql> use veterinaria;
Database changed
mysql> select*from clientes1;
+------------+-----------------+----------------------+----------+--------------+
| NCliente | nombreCliente |
direccion |
tel |
oficio |
+------------+-----------------+----------------------+----------+--------------+
| 1 | Deivan
Herrera | colombia #012 |
6893494 | Estudiante |
| 2 | Ricardo
Garcia | aeropuerto #2109 |
6100023 | Estudiante |
| 3
| Melissa Aguilar | geranios #5321 | 6192828 |
Estudiante |
+------------+-----------------+----------------------+----------+--------------+
3 rows in set (0.21 sec)
mysql> insert into
clientes1 values(04,'jessica Barrios','consumidor #5690','6734234','Estudiante');
Query OK, 1 row affected
(0.01 sec)
mysql> insert into clientes1
values(05,'Luis Armenta','bromo #9840','6934929'Estudiante');
Query OK, 1 row affected
(0.01 sec)
mysql> select*from clientes1;
+------------+-----------------+----------------------+----------+--------------+
| NCliente | nombreCliente |
direccion |
tel |
oficio |
+------------+-----------------+----------------------+----------+--------------+
| 1 | Ricardo
Hernandez | fidelvelazquez #012 |
6847394 | Estudiante |
| 2 | Isabel lopez |
juarez#2039 | 61924847 |
Estudiante |
| 3 | Melissa |
telurio #456 | 6109092 | Estudiante |
| 4 | Itzel lazcano |
laguna verde #2345 | 10002340 | Estudiante |
| 5
| ivan | begnias #3456 |
69111233 | Estudiante |
+------------+-----------------+----------------------+----------+--------------+
5 rows in set (0.01 sec)
mysql> select*from
mascotas;
+------+--------+------+------+--------------+-------------+
| NumP | nombre | peso | sexo |
raza | FNacimiento |
+------+--------+------+------+--------------+-------------+
| 1 | peluche | 0.9 | M |
Chihuahua | 03-05-2011 |
| 2 | bandam| 0.6 | M | Chihuahua |
28-06-2012 |
+------+--------+------+------+--------------+-------------+
2 rows in set (0.15 sec)
mysql> insert into
mascotas values(3,'bigotes',7,'H','frezhpool','15-02-2009');
Query OK, 1 row affected
(0.00 sec)
mysql> insert into
mascotas values(4,'wera',5,'M','shorpey','13-11-2004');
Query OK, 1 row affected
(0.00 sec)
mysql> insert into
mascotas values(5,'popy',10,'H','kocker ','05-06-2000');
Query OK, 1 row affected
(0.00 sec)
mysql> select*from
mascotas;
+------+--------+------+------+--------------+-------------+
| NumP | nombre | peso |
sexo | raza | FNacimiento
|
+------+--------+------+------+--------------+-------------+
| 1
| peluche | 0.9 | M |
Chihuahua | 03-05-2011 |
| 2
| bandam | 0.6 | M | Chihuahua | 28-06-2012 |
| 3
| princess | 7 | H | frezhpool | 15-02-2009 |
| 4
| morgan| 5 | M | shorpey | 13-11-2004 |
| 5
| cokis| 10 | H | kocker | 05-06-2000 |
+------+--------+------+------+----------------+-------------+
5 rows in set (0.00 sec)
mysql> show tables;
+-------------------+
| Tables_in_veterinaria |
+-------------------+
| antenfermedades |
| clientes1 |
| direccion |
| hmedica |
|
info |
| mascotas |
| mconsulta |
|
servicios |
|
veterinaria |
+-------------------+
10 rows in set (0.71 sec)
mysql> exit
No hay comentarios:
Publicar un comentario