Práctica MySQL 1, MySQL

Práctica MySQL 1

/*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","08/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","03/9/08");
INSERT INTO datosper Values ("Jorge Guajardo","San José de la Joya","844662340","10/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","2005","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","2004","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;


run \| edit \| history \| help	0