Video tutorial de cÃ³mo crear tablas y relacionarlas en mysql

Video tutorial de cÃ³mo crear tablas en mysql, relaciones entre tablas, y modificar las columnas.
TambiÃ©n cÃ³mo insertar registros en las tablas, y relacionarlos en mysql utilizando InnoDB.
RelaciÃ³n 1 - N

PodÃ©is encontrar el cÃ³digo del video mÃ¡s abajo.

mysql> create database testdb;
Query OK, 1 row affected (0.00 sec)

mysql> use testdb;
Database changed
mysql> show tables;
Empty set (0.00 sec)

mysql> create table usuarios(id int primary key auto_increment,nick varchar(50) not null,nombre varchar(100),administrador boolean default false)Engine=InnoDB; 
Query OK, 0 rows affected (0.08 sec)

mysql> show tables;
+------------------+
| Tables_in_testdb |
+------------------+
| usuarios         |
+------------------+
1 row in set (0.00 sec)

mysql> create table privilegios(id int(3) primary key,descripcion text)Engine=InnoDB;
Query OK, 0 rows affected (0.02 sec)

mysql> insert into privilegios(id,descripcion) VALUES (1,"Superadministrador burtal");
Query OK, 1 row affected (0.08 sec)

mysql> insert into privilegios(id,descripcion) VALUES (2,"Usuario basico");Query OK, 1 row affected (0.08 sec)

mysql> insert into privilegios(id,descripcion) VALUES (3,"Usuario noob");
Query OK, 1 row affected (0.01 sec)

mysql> select * from privilegios;
+----+---------------------------+
| id | descripcion               |
+----+---------------------------+
|  1 | Superadministrador burtal |
|  2 | Usuario basico            |
|  3 | Usuario noob              |
+----+---------------------------+
3 rows in set (0.00 sec)

mysql> alter table usuarios add privilegio int(3) references privilegios(id);
Query OK, 0 rows affected (0.12 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> insert into usuarios (nick,nombre,privilegio) VALUES ("user1","Antonio",1);
Query OK, 1 row affected (0.15 sec)

mysql> insert into usuarios (nick,nombre,privilegio) VALUES ("user2","Pepa",2);Query OK, 1 row affected (0.10 sec)

mysql> insert into usuarios (nick,nombre,privilegio) VALUES ("user3","Juana",2);
Query OK, 1 row affected (0.01 sec)

mysql> insert into usuarios (nick,nombre,privilegio) VALUES ("user4","Castaneda",3);
Query OK, 1 row affected (0.07 sec)

mysql> select * from usuarios;
+----+-------+-----------+---------------+------------+
| id | nick  | nombre    | administrador | privilegio |
+----+-------+-----------+---------------+------------+
|  1 | user1 | Antonio   |             0 |          1 |
|  2 | user2 | Pepa      |             0 |          2 |
|  3 | user3 | Juana     |             0 |          2 |
|  4 | user4 | Castaneda |             0 |          3 |
+----+-------+-----------+---------------+------------+
4 rows in set (0.00 sec)

mysql> alter table usuarios modify administrador boolean default true;
Query OK, 0 rows affected (0.06 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> alter table usuarios drop administrador;
Query OK, 4 rows affected (0.11 sec)
Records: 4  Duplicates: 0  Warnings: 0

ProgramaciÃ³n

Mysql

Terminal ubuntu