Ejemplo sencillo de una base de datos

Setting environment for using XAMPP for Windows.
Francisco Duran@FRANCISCODURAN c:\nueva carpeta
# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.6.16 MySQL Community Server (GPL)

Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark ofOracle 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 practicas
Database changed
mysql> create table alumnos(
-> matricula varchar(10),
-> nombre varchar(15),
-> apellidos varchar(20),
-> fecha_nac date,
-> direccionvarchar(20),
-> ciudad varchar(20),
-> estado varchar(20),
-> curso numeric,
-> nivel varchar(3),
-> clase char(2),
-> faltas1 numeric,
-> faltas2 numeric,
-> faltas3 numeric);
Query OK, 0 rows affected (0.45 sec)

mysql> show columns from alumnos;
+-----------+---------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default |Extra |
+-----------+---------------+------+-----+---------+-------+
| matricula | varchar(10) | YES | | NULL | |
| nombre | varchar(15) | YES | | NULL | |
| apellidos | varchar(20) | YES | | NULL | |
| fecha_nac | date | YES | | NULL | |
| direccion | varchar(20) | YES | | NULL | |
| ciudad |varchar(20) | YES | | NULL | |
| estado | varchar(20) | YES | | NULL | |
| curso | decimal(10,0) | YES | | NULL | |
| nivel | varchar(3) | YES | | NULL | |
| clase | char(2) | YES | | NULL | |
| faltas1 | decimal(10,0) | YES | | NULL | |
| faltas2 | decimal(10,0) | YES | |NULL | |
| faltas3 | decimal(10,0) | YES | | NULL | |
+-----------+---------------+------+-----+---------+-------+
13 rows in set (0.03 sec)

****** Ingresa 20 registros con información en la tabla Alumnos.*****

mysql>mysql> insert into alumnos values(
-> 111,'luis','duran',"1997-08-25",'caracol #20','carmen','campeche',1,'ESO'
,'1a',1,0,1);
Query OK, 1row affected (0.08 sec)

mysql> insert into alumnos values(
-> 112,'juan','duran',"2000-02-27",'caracol #20','carmen','campeche',1,'ESO'
,'1a',0,3,2);
Query OK, 1 row affected (0.07 sec)

mysql> insert into alumnos values(
-> 113,'lizeth','ramirez',"1999-08-13",'av.albatros #32','guadalajara','jali
sco',1,'ESO','1a',1,1,1);
Query OK, 1 row affected (0.08 sec)

mysql> insertinto alumnos values(
-> 114,'guadalupe','perez',"1995-09-29",'av.ballena #321','guadalajara','jal
isco',1,'ESO','1a',2,5,0);
Query OK, 1 row affected (0.07 sec)

mysql> insert into alumnos values(
-> 115,'rosymar','quej',"1995-11-26",'ortiz avila #13','escarsega','campeche
',1,'ESO','1a',0,0,0);
Query OK, 1 row affected (0.08 sec)

mysql> insert into alumnos values(
->222,'rosario','gonzalez',"1996-10-07",'ortiz avila #23','escarsega','camp
eche',2,'BAC','2b',0,0,2);
Query OK, 1 row affected (0.08 sec)

mysql> insert into alumnos values(
-> 221,'carmen','mendoza',"1997-10-30",'manigua #113','carmen','campeche',2,
'BAC','2b',0,1,2);
Query OK, 1 row affected (0.07 sec)

mysql> insert into alumnos values(
->223,'maria','dominguez',"1997-05-01",'constitucion #215','cocotlan','jali
sco',2,'BAC','2b',0,0,0);
Query OK, 1 row affected (0.07 sec)

mysql> insert into alumnos values(
-> 224,'ramon','torres',"1997-08-31",'reforma #379','cocotlan','jalisco',2,'
DAI','2b',0,1,0);
Query OK, 1 row affected (0.04 sec)

mysql> insert into alumnos values(
-> 225,'francisco','lopez',"1999-07-22",'agraria #1267','paraiso','tabasco',...