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 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
| Deivan Herrera | colombia #012 |
6893494 | Estudiante |
| 2
| Ricardo Garcia | aeropuerto #2109 |
6100023 | Estudiante |
| 3
| Melissa Aguilar | geranios #5321 | 6192828 |
Estudiante |
| 4
| Jessica Barrios | consumidor #5690 | 6734234 | Estudiante |
| 5
| Luis Armenta | bromo #9840 | 6934929 |
Estudiante |
+------------+-----------------+----------------------+----------+--------------+
5
rows in set (0.01 sec)
mysql>
select*from mascotas;
+------+--------+------+------+--------------+-------------+
| NumP | nombre | peso | sexo |
raza | FNacimiento |
+------+--------+------+------+--------------+-------------+
| 1 | gomita | 0.9
| M | Chihuahua | 03-05-2011 |
| 2 | burbuja | 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
| gomita | 0.9 | M |
Chihuahua | 03-05-2011 |
| 2
| burbuja | 0.6 | M | Chihuahua | 28-06-2012 |
| 3
| bigotes | 7 | H | frezhpool | 15-02-2009 |
| 4
| wera | 5 | M | shorpey | 13-11-2004 |
| 5
| popy | 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