Skip to content

Latest commit

 

History

History
42 lines (37 loc) · 1.19 KB

Clase8.md

File metadata and controls

42 lines (37 loc) · 1.19 KB
Raw

paso a paso

  • ir a ejemploCrud de esta clase
  • levantar docker:
docker-compose up -d
  • comprobar maquinas:
docker ps
  • conectar la base de datos (los datos estan en docker-compose)
host: localhost
port: 9906
user: root
pass: rootsecretpass
  • crear tabla de users
CREATE TABLE `clase8`.`users` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(45) NOT NULL,
  `email` VARCHAR(45) NOT NULL,
  `sexo` ENUM('F', 'M', 'N') NOT NULL,
  PRIMARY KEY (`id`));
  • insertar valores
INSERT INTO `clase8`.`users` (`name`, `email`, `sexo`) VALUES ('mari', 'mari@fakemails', 'F');
INSERT INTO `clase8`.`users` (`name`, `email`, `sexo`) VALUES ('rosa', '[email protected]', 'F');
INSERT INTO `clase8`.`users` (`name`, `email`, `sexo`) VALUES ('luis', '[email protected]', 'M');
INSERT INTO `clase8`.`users` (`name`, `email`, `sexo`) VALUES ('komai', '[email protected]', 'N');
INSERT INTO `clase8`.`users` (`name`, `email`, `sexo`) VALUES ('mario', '[email protected]', 'M');
INSERT INTO `clase8`.`users` (`name`, `email`, `sexo`) VALUES ('paqui', '[email protected]', 'F');
INSERT INTO `clase8`.`users` (`name`, `email`, `sexo`) VALUES ('antonio', '[email protected]', 'M');