CREATE DATABASE escritopw;

USE escritopw;


CREATE TABLE datos(
telefono int(9) unsigned zerofill,
nombre varchar(20),

apellido varchar(20),
fechanac date,
PRIMARY KEY(telefono));



insert into datos values
(099123456,'Mengano', 'de Tal','1999-09-19'),

(099234567,'Sultano', 'de Tal','1999-09-19'),

(099312345,'Ben', 'Once','1999-09-11'),
(099412345,'Fulano', 'de Tal','1999-10-19'),

(099512345,'Ale', 'Van Tarse','1999-11-19'),
(099612345,'Elsa', 'Pato','1999-09-21'),

(099712345,'Susana', 'Horia','1998-12-19'),
(099812345,'Esteban', 'Quito','1997-11-18'),

(099912345,'N. L. C.', 'Jhon','1996-08-17'),
(098223456,'Elsa', 'Lame','1995-07-16'),

(098323456,'Elsa', 'Payo','1994-06-15'),
(098523456,'Homero', 'Sinson','1993-05-14'),

(097423456,'Lisa', 'Sinson','1994-04-13'),
(097223456,'Barto', 'Sinson','1995-03-12'),

(097123456,'Margerine', 'Sinson','1996-02-11'),
(096123456,'Mengana', 'de Tallez','1997-01-10'),

(095123456,'Sultana', 'de Tallez','1998-12-09'),
(094123456,'Bruno', 'Diez','1999-11-11');