Actividad 19

Actividad #19

mysql> create user Admin identified by 'Admin1';

Query OK, 0 rows affected (0.02 sec)

mysql> create user Med identified by 'Med1';

Query OK, 0 rows affected (0.01 sec)

mysql> create user Asist identified by 'Asist1';

Query OK, 0 rows affected (0.00 sec)

mysql> select  user();

+----------------+

| user()         |

+----------------+

| root@localhost |

+----------------+

1 row in set (0.04 sec)

mysql> grant all privileges on veterin.* to 'Admin'with grant option;

Query OK, 0 rows affected (0.10 sec)

mysql> grant insert,update,delete,select  on veterinaria.* to 'Med'@'localhost';

Query OK, 0 rows affected (1.35 sec)

mysql> grant all privileges on veterin.* to 'Admin'with grant option;

Query OK, 0 rows affected (0.00 sec)

mysql> grant insert,update,delete,select  on veterinaria.* to 'Med'@'localhost';

Query OK, 0 rows affected (0.00 sec)

mysql> grant select  on veterin.* to 'Asist'@'localhost';

Query OK, 0 rows affected (0.01 sec)

mysql> show databases;

+--------------------+

| Database           |

+--------------------+

| information_schema |

| cdcol              |

| mysql              |

| performance_schema |

| phpmyadmin         |

| test               |

| veterinaria            |

| webauth            |

+--------------------+

8 rows in set (0.01 sec)

mysql> use veterinaria;

Database changed

mysql> select user();

+----------------+

| user()         |

+----------------+

| root@localhost |

+----------------+

1 row in set (0.11 sec)

mysql> exit

Actividad # 18

Actividad 18

mysql> use veterinaria;

Database changed

mysql> select*from clientes1;

+------------+-----------------+----------------------+----------+--------------+

| NCliente | nombreCliente    | direccion            | tel         | oficio       |

+------------+-----------------+----------------------+----------+--------------+

|          1 | Ricardo Hernandez| Fidel velazquez #0423      | 6893494  | Estudiante    |

|          2 | Alexa maria      | juarez #2390      | 69384223  | Estudiante |

|          3 | Javier Aguilar    | telurio #2321 | 610000 | 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