mysql>
create database veterinaria;
Query OK, 1
row affected (0.05 sec)
mysql>
use veterinaria;
Database
changed
mysql> create table datos(ID varchar(20),nombre
varchar(30),profesion varchar(30),direccion varchar(30),telefono int(15));
Query OK, 0
rows affected (0.28 sec)
mysql>
DESCRIBE datos;
+-----------+-------------+------+-----+---------+-------+
|
Field | Type | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+-------+
| ID | varchar(20) | YES | |
NULL | |
|
nombre | varchar(30) | YES | |
NULL | |
| profesion
| varchar(30) | YES | | NULL
| |
| direccion
| varchar(30) | YES | | NULL
| |
|
telefono | int(15) | YES
| | NULL
| |
+-----------+-------------+------+-----+---------+-------+
5 rows in
set (0.10 sec)
mysql> insert datos values(0001,'kevin','ingeniero','horiz.sur','6566831212');
Query OK, 1
row affected, 1 warning (0.13 sec)
mysql> insert datos values(0002,'brayan','barrendero','juarez nvo','6561111111');
Query OK, 1
row affected, 1 warning (0.03 sec)
mysql> insert datos
values(0003,'sergio','doctora','centro','6562222222');
Query OK, 1
row affected, 1 warning (0.05 sec)
mysql> insert datos values(0004,'pedro','chef','misiones','6563333333');
Query OK, 1
row affected, 1 warning (0.04 sec)
mysql> insert datos values(0005,'sergio','licenciado','zaragosa','6564444444');
Query OK, 1
row affected, 1 warning (0.04 sec)
mysql> Select*FROM datos;
+------+----------+------------+------------+----------+
| ID | nombre | profesion
| direccion | telefono |
+------+----------+------------+------------+----------+
| 1 | kevin | ingeniero
| horiz.sur |
6566831212 |
| 2 | brayan |
barrendero | juarez nvo. |
6561111111 |
| 3 | sergio | doctora | centro | 6562222222 |
| 4 | pedro | chef | misiones |
6563333333 |
| 5 | sergio | licenciado| zaragosa |
6564444444 |
+------+----------+------------+------------+----------+
5 rows in set (0.03 sec)
mysql> create table visita(nombre char(30)not null,razon
CHAR(60),fecha varchar(
15));
Query OK, 0 rows affected (0.12 sec)
mysql> show
tables;
+---------------------+
|
Tables_in_veterinaria|
+---------------------+
| datos |
|
visita |
+---------------------+
2 rows in
set (0.04 sec)
mysql> insert
into visita values('federico','intoxicacion','23/11/13');
Query OK, 1
row affected (0.04 sec)
mysql> insert
into visita values('irasel','vacunas','26/05/13');
Query OK, 1
row affected (0.05 sec)
mysql>
insert into visita values('hector','chequeo','20/06/13');
Query OK, 1
row affected (0.05 sec)
mysql>
insert into visita values('ariel','baño','14/02/13');
Query OK, 1
row affected (0.05 sec)
mysql> insert
into visita values('saul','estomago','08/09/13');
Query OK, 1
row affected (0.05 sec)
mysql> select *from visita;
+---------+-----------+----------+
| nombre | razon | fecha
|
+---------+-----------+----------+
| federico | intoxicacion | 23/11/13 |
| irasel | vacunas | 26/05/13 |
| hector |chequeo | 20/06/13|
|ariel | baño | 14/02/13 |
| saul |estomago | 08/09/13 |
+---------+-----------+----------+
6 rows in
set (0.00 sec)
mysql>
show databases;
+--------------------+
|
Database |
+--------------------+
| information_schema |
| agregar |
| alumnos |
| borrado |
| cdcol |
| clinica |
| dorrado |
| indices |
| mysql |
|
performance_schema |
|
phpmyadmin |
|
renombrar |
| test |
|
veterinaria |
|
webauth |
+--------------------+
16 rows in
set (0.07 sec)
mysql>
use veterinaria;
Database
changed
mysql>
show tables;
+---------------------+
|
Tables_in_veterinaria |
+---------------------+
| datos |
|
visita |
+---------------------+
2 rows in
set (0.01 sec)
mysql>
create user 'veterinario'@'localhost'identified by'veterinario_pass';
Query OK, 0
rows affected (0.09 sec)
mysql>
create user 'asistente'@'localhost'identified by'asistente_pass';
Query OK, 0
rows affected (0.00 sec)
mysql> grant
select,update on veterinaria.*to eder identified by'veterinario_pa
ss';
Query OK, 0
rows affected (0.03 sec)
mysql> grant
select,insert on veterinaria.*to eder identified by'veterinario_pa
ss';
Query OK, 0
rows affected (0.00 sec)
mysql> grant
select,delete on veterinaria.*to eder identified by'veterinario_pa
ss';
Query OK, 0
rows affected (0.00 sec)
mysql> grant
select,update on veterinaria.*to eder identified by'asistente_pass
';
Query OK, 0
rows affected (0.00 sec)
mysql> grant
select,create on veterinaria.*to eder identified by'asistente_pass
';
Query OK, 0
rows affected (0.00 sec)
mysql> grant
select,delete on veterinaria.*to eder identified by'asistente_pass
';
Query OK, 0
rows affected (0.00 sec)
1.-status de la tabla
2.-creacion del index
3.-obtener el tamaño de la base de datos
No hay comentarios:
Publicar un comentario