Práctica MySQL 2, MySQL

Práctica MySQL 2

/*Edson Arriaga Ortiz*/
/*
CREATE TABLE datosper (nombre VARCHAR (30), direccion VARCHAR(50), telefono INT(10), nacimiento DATE);
*/

INSERT INTO datosper Values ("Edson Arriaga Ortiz","Zaragoza 300","844662340","08-10-03");
INSERT INTO datosper Values ("Luis Mireles","Encarnación de Guzmán","844662340","12/10/09");
INSERT INTO datosper Values ("Kevin Orlando","Guadalupe Victoria","844662340","97/12/07");
INSERT INTO datosper Values ("Carlos Ortiz","José María Morelos","844662340","07/5/01");
INSERT INTO datosper Values ("Jose Martin","Presa de San Pedro","844662340","98/9/08");
INSERT INTO datosper Values ("Jorge Guajardo","San José de la Joya","844662340","99/11/02");
select * from datosper;
/*
CREATE TABLE musicadat (Titulo VARCHAR(25),Interprete VARCHAR(20),Año SMALLINT(5), Duracion TIME,Autor VARCHAR(20));
*/
INSERT INTO musicadat Values("Before I Forget","kori taylor","1960","00:05:21","kori taylor");
INSERT INTO musicadat Values("Disasterpiece","kori taylor","2001","00:03:20","kori taylor");
INSERT INTO musicadat Values("Duality ","kori taylor","2004","00:06:03","kori taylor");
INSERT INTO musicadat Values("Vermillion ","kori taylor","1997","00:04:21","kori taylor");
INSERT INTO musicadat Values("Lef Behind","kori taylor","2001","00:03:54","kori taylor");
INSERT INTO musicadat Values("Snuff","kori taylor","2008","00:02:26","kori taylor");
select * from musicadat;

/*Edson Arriaga Ortiz*/
select Titulo,Interprete from musicadat;

select nombre,telefono from datosper;

select nombre,direccion,nacimiento from datosper
where year (nacimiento)<2000;

select Titulo,Año,Autor from musicadat
where Año >1999 AND Año <2011;


run \| edit \| history \| help	0