Programación 2: Base de Datos con datos de ejemplo

ejemplo.sql

drop database if exists `sistemaJ`;

create database `sistemaJ`;
use `sistemaJ`;

DROP TABLE IF EXISTS `usuarios`;

CREATE TABLE `usuarios` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `nombre` varchar(255) default NULL,
  `apellido` varchar(255) default NULL,
  `email` varchar(255) default NULL,
  `fecha_registro` datetime default current_timestamp,
  PRIMARY KEY (`id`)
) AUTO_INCREMENT=1;

INSERT INTO `usuarios` (`nombre`,`apellido`,`email`,`fecha_registro`)
VALUES
  ("Kelly","Avery","[email protected]","2024-08-29 11:13:36"),
  ("Zia","Tillman","[email protected]","2025-07-15 04:53:39"),
  ("Danielle","Meyers","[email protected]","2024-11-23 02:33:37"),
  ("Donna","Martin","[email protected]","2025-06-28 17:13:47"),
  ("Libby","Strong","[email protected]","2025-07-29 17:50:29"),
  ("Jorden","Sparks","[email protected]","2025-05-27 04:06:34"),
  ("Damian","Shaffer","[email protected]","2025-02-14 02:07:16"),
  ("Scarlet","Gill","[email protected]","2025-02-06 10:33:20"),
  ("Xandra","Calderon","[email protected]","2025-07-19 04:19:06"),
  ("Grace","Bell","[email protected]","2025-02-03 09:17:45"),
  ("Desirae","Ryan","[email protected]","2024-11-23 20:35:10"),
  ("Brody","Contreras","[email protected]","2024-10-15 18:34:32"),
  ("Brianna","Velazquez","[email protected]","2025-01-04 14:06:49"),
  ("Eaton","Blankenship","[email protected]","2025-06-14 00:39:25"),
  ("Savannah","Melendez","[email protected]","2025-07-04 15:57:56"),
  ("Cherokee","Franco","[email protected]","2025-02-12 10:33:39"),
  ("Blaze","Boyd","[email protected]","2025-06-30 23:34:31"),
  ("Leo","Tillman","[email protected]","2025-04-22 07:41:26"),
  ("Gregory","Dunlap","[email protected]","2025-04-29 08:06:09"),
  ("Duncan","Mcdonald","[email protected]","2024-11-14 10:15:24"),
  ("Zane","Payne","[email protected]","2025-04-18 20:49:10"),
  ("Odysseus","Brennan","[email protected]","2024-10-25 13:17:13"),
  ("Fletcher","Wagner","[email protected]","2025-06-23 02:34:07"),
  ("Amir","Rivas","[email protected]","2025-04-15 17:41:56"),
  ("Zane","Gilmore","[email protected]","2024-11-23 18:45:26"),
  ("Drew","Macias","[email protected]","2025-02-22 17:53:09"),
  ("Kamal","Sanders","[email protected]","2025-04-15 15:02:17"),
  ("Rajah","Wiley","[email protected]","2025-03-04 02:34:45"),
  ("Aimee","Justice","[email protected]","2025-05-01 06:08:45"),
  ("Lani","Dawson","[email protected]","2025-08-15 02:36:33"),
  ("Brenden","Velasquez","[email protected]","2025-07-02 09:28:00"),
  ("Plato","Browning","[email protected]","2025-07-14 13:06:30"),
  ("Karyn","Hooper","[email protected]","2025-06-13 04:51:41"),
  ("Kuame","Armstrong","[email protected]","2025-05-25 06:13:27"),
  ("Ainsley","Pittman","[email protected]","2025-05-07 16:25:42"),
  ("Jin","Duke","[email protected]","2025-06-13 05:26:59"),
  ("Reece","Harper","[email protected]","2025-03-14 10:56:07"),
  ("Marvin","Wilcox","[email protected]","2025-04-18 19:22:50"),
  ("Dalton","Pace","[email protected]","2025-03-22 18:15:54"),
  ("Gage","Sharpe","[email protected]","2025-01-30 13:40:54"),
  ("Conan","Trujillo","[email protected]","2024-10-28 08:52:24"),
  ("Colette","Lynch","[email protected]","2024-11-14 18:18:06"),
  ("Brennan","Castillo","[email protected]","2025-01-05 03:13:18"),
  ("Caldwell","Blankenship","[email protected]","2024-10-31 04:04:11"),
  ("Gisela","Clemons","[email protected]","2025-05-11 21:15:11"),
  ("Medge","Pitts","[email protected]","2024-11-19 16:32:46"),
  ("Illana","Cunningham","[email protected]","2025-07-29 19:33:05"),
  ("Declan","Mcpherson","[email protected]","2025-08-08 14:36:17"),
  ("Yoshio","Hart","[email protected]","2024-09-02 21:37:30"),
  ("Palmer","O'connor","[email protected]","2025-03-14 22:04:14");
INSERT INTO `usuarios` (`nombre`,`apellido`,`email`,`fecha_registro`)
VALUES
  ("Marvin","Noel","[email protected]","2024-10-31 03:55:30"),
  ("Baxter","Hewitt","[email protected]","2025-05-27 23:40:02"),
  ("Bell","Richmond","[email protected]","2025-07-22 09:42:10"),
  ("Zelda","Hensley","[email protected]","2024-12-17 16:06:43"),
  ("Kato","Perkins","[email protected]","2025-02-28 18:44:58"),
  ("Channing","Dillard","[email protected]","2025-01-23 06:32:52"),
  ("August","George","[email protected]","2024-10-08 09:52:33"),
  ("Iris","Mcguire","[email protected]","2024-12-29 07:09:01"),
  ("Octavius","Noel","[email protected]","2024-12-27 02:08:32"),
  ("Hedwig","Ruiz","[email protected]","2025-01-21 06:54:16"),
  ("Simon","Davidson","[email protected]","2025-04-01 18:58:32"),
  ("Hiram","Haney","[email protected]","2025-01-17 02:56:12"),
  ("Tad","Peck","[email protected]","2025-04-21 21:23:07"),
  ("Daphne","Raymond","[email protected]","2025-01-15 22:46:26"),
  ("Kevin","Keith","[email protected]","2025-04-18 01:30:25"),
  ("Caleb","Dean","[email protected]","2025-01-18 10:01:57"),
  ("Britanney","Kirk","[email protected]","2024-09-09 18:35:49"),
  ("Whoopi","Moody","[email protected]","2024-09-16 03:07:25"),
  ("Hall","Campbell","[email protected]","2025-05-12 01:04:27"),
  ("Erin","Leonard","[email protected]","2024-12-28 21:09:10"),
  ("Aurelia","Chambers","[email protected]","2025-05-10 17:34:43"),
  ("Emi","Mosley","[email protected]","2025-07-23 18:05:43"),
  ("Avram","Reid","[email protected]","2024-09-29 02:03:02"),
  ("Kieran","Wilkerson","[email protected]","2025-08-03 19:23:26"),
  ("Virginia","Harrell","[email protected]","2025-03-17 11:48:46"),
  ("Price","Coffey","[email protected]","2025-07-30 04:23:58"),
  ("Oprah","Foster","[email protected]","2025-06-09 17:53:20"),
  ("Alexander","Norris","[email protected]","2024-10-16 12:02:17"),
  ("Justine","Lamb","[email protected]","2025-08-09 12:34:59"),
  ("Ryder","Woodard","[email protected]","2025-06-02 11:04:11"),
  ("Baxter","Greer","[email protected]","2025-07-02 07:55:05"),
  ("Vielka","Allen","[email protected]","2025-02-27 14:18:05"),
  ("Quin","Duncan","[email protected]","2024-09-27 01:41:55"),
  ("Beatrice","Tanner","[email protected]","2024-12-26 22:54:01"),
  ("Hunter","Moody","[email protected]","2024-12-16 00:18:24"),
  ("Xanthus","Armstrong","[email protected]","2024-11-09 22:05:30"),
  ("Mark","Green","[email protected]","2025-07-17 11:37:10"),
  ("Colby","English","[email protected]","2024-12-16 23:53:08"),
  ("Alden","Dunlap","[email protected]","2025-02-12 11:31:38"),
  ("Jessamine","Cortez","[email protected]","2025-08-04 22:58:22"),
  ("Wanda","Rogers","[email protected]","2025-01-27 05:50:13"),
  ("Reuben","Short","[email protected]","2024-09-26 00:06:29"),
  ("Mannix","Boyle","[email protected]","2024-12-29 22:11:17"),
  ("Lunea","Vinson","[email protected]","2024-11-03 12:38:58"),
  ("Martina","Dixon","[email protected]","2025-06-19 09:22:37"),
  ("Genevieve","Mcdonald","[email protected]","2025-08-05 01:32:56"),
  ("Leslie","Jacobs","[email protected]","2025-01-03 21:10:39"),
  ("Noel","Dyer","[email protected]","2024-09-24 06:15:56"),
  ("Jesse","Leblanc","[email protected]","2025-06-20 00:09:01"),
  ("Michael","Kemp","[email protected]","2024-10-12 04:48:32");