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","avery7218@aol.ca","2024-08-29 11:13:36"),
  ("Zia","Tillman","tillman2232@outlook.edu","2025-07-15 04:53:39"),
  ("Danielle","Meyers","meyers8555@aol.net","2024-11-23 02:33:37"),
  ("Donna","Martin","martin@hotmail.ca","2025-06-28 17:13:47"),
  ("Libby","Strong","strong@yahoo.com","2025-07-29 17:50:29"),
  ("Jorden","Sparks","sparks@outlook.org","2025-05-27 04:06:34"),
  ("Damian","Shaffer","shaffer9145@aol.com","2025-02-14 02:07:16"),
  ("Scarlet","Gill","gill6778@protonmail.net","2025-02-06 10:33:20"),
  ("Xandra","Calderon","calderon@aol.ca","2025-07-19 04:19:06"),
  ("Grace","Bell","bell@yahoo.com","2025-02-03 09:17:45"),
  ("Desirae","Ryan","ryan@icloud.com","2024-11-23 20:35:10"),
  ("Brody","Contreras","contreras9000@icloud.com","2024-10-15 18:34:32"),
  ("Brianna","Velazquez","velazquez6650@google.org","2025-01-04 14:06:49"),
  ("Eaton","Blankenship","blankenship@protonmail.org","2025-06-14 00:39:25"),
  ("Savannah","Melendez","melendez9396@icloud.com","2025-07-04 15:57:56"),
  ("Cherokee","Franco","franco@icloud.net","2025-02-12 10:33:39"),
  ("Blaze","Boyd","boyd9748@aol.edu","2025-06-30 23:34:31"),
  ("Leo","Tillman","tillman@protonmail.edu","2025-04-22 07:41:26"),
  ("Gregory","Dunlap","dunlap@google.edu","2025-04-29 08:06:09"),
  ("Duncan","Mcdonald","mcdonald@aol.com","2024-11-14 10:15:24"),
  ("Zane","Payne","payne@outlook.ca","2025-04-18 20:49:10"),
  ("Odysseus","Brennan","brennan@yahoo.com","2024-10-25 13:17:13"),
  ("Fletcher","Wagner","wagner8917@outlook.net","2025-06-23 02:34:07"),
  ("Amir","Rivas","rivas9544@google.couk","2025-04-15 17:41:56"),
  ("Zane","Gilmore","gilmore@google.net","2024-11-23 18:45:26"),
  ("Drew","Macias","macias387@hotmail.edu","2025-02-22 17:53:09"),
  ("Kamal","Sanders","sanders2234@aol.edu","2025-04-15 15:02:17"),
  ("Rajah","Wiley","wiley@icloud.com","2025-03-04 02:34:45"),
  ("Aimee","Justice","justice1557@icloud.com","2025-05-01 06:08:45"),
  ("Lani","Dawson","dawson8535@outlook.com","2025-08-15 02:36:33"),
  ("Brenden","Velasquez","velasquez@yahoo.com","2025-07-02 09:28:00"),
  ("Plato","Browning","browning8856@icloud.net","2025-07-14 13:06:30"),
  ("Karyn","Hooper","hooper4286@protonmail.ca","2025-06-13 04:51:41"),
  ("Kuame","Armstrong","armstrong4452@google.com","2025-05-25 06:13:27"),
  ("Ainsley","Pittman","pittman9822@aol.net","2025-05-07 16:25:42"),
  ("Jin","Duke","duke@outlook.org","2025-06-13 05:26:59"),
  ("Reece","Harper","harper@google.edu","2025-03-14 10:56:07"),
  ("Marvin","Wilcox","wilcox3812@yahoo.edu","2025-04-18 19:22:50"),
  ("Dalton","Pace","pace@hotmail.org","2025-03-22 18:15:54"),
  ("Gage","Sharpe","sharpe@aol.org","2025-01-30 13:40:54"),
  ("Conan","Trujillo","trujillo@yahoo.couk","2024-10-28 08:52:24"),
  ("Colette","Lynch","lynch3925@hotmail.org","2024-11-14 18:18:06"),
  ("Brennan","Castillo","castillo@protonmail.net","2025-01-05 03:13:18"),
  ("Caldwell","Blankenship","blankenship@outlook.edu","2024-10-31 04:04:11"),
  ("Gisela","Clemons","clemons@protonmail.org","2025-05-11 21:15:11"),
  ("Medge","Pitts","pitts4842@outlook.org","2024-11-19 16:32:46"),
  ("Illana","Cunningham","cunningham4029@hotmail.edu","2025-07-29 19:33:05"),
  ("Declan","Mcpherson","mcpherson9793@protonmail.com","2025-08-08 14:36:17"),
  ("Yoshio","Hart","hart1070@icloud.com","2024-09-02 21:37:30"),
  ("Palmer","O'connor","oconnor@icloud.net","2025-03-14 22:04:14");
INSERT INTO `usuarios` (`nombre`,`apellido`,`email`,`fecha_registro`)
VALUES
  ("Marvin","Noel","noel@google.edu","2024-10-31 03:55:30"),
  ("Baxter","Hewitt","hewitt@protonmail.couk","2025-05-27 23:40:02"),
  ("Bell","Richmond","richmond3000@aol.edu","2025-07-22 09:42:10"),
  ("Zelda","Hensley","hensley4393@aol.ca","2024-12-17 16:06:43"),
  ("Kato","Perkins","perkins4075@outlook.org","2025-02-28 18:44:58"),
  ("Channing","Dillard","dillard9471@google.couk","2025-01-23 06:32:52"),
  ("August","George","george266@hotmail.edu","2024-10-08 09:52:33"),
  ("Iris","Mcguire","mcguire3493@icloud.net","2024-12-29 07:09:01"),
  ("Octavius","Noel","noel7381@outlook.couk","2024-12-27 02:08:32"),
  ("Hedwig","Ruiz","ruiz@aol.edu","2025-01-21 06:54:16"),
  ("Simon","Davidson","davidson@hotmail.com","2025-04-01 18:58:32"),
  ("Hiram","Haney","haney@icloud.org","2025-01-17 02:56:12"),
  ("Tad","Peck","peck1243@outlook.com","2025-04-21 21:23:07"),
  ("Daphne","Raymond","raymond@protonmail.org","2025-01-15 22:46:26"),
  ("Kevin","Keith","keith@protonmail.couk","2025-04-18 01:30:25"),
  ("Caleb","Dean","dean@hotmail.edu","2025-01-18 10:01:57"),
  ("Britanney","Kirk","kirk9177@aol.couk","2024-09-09 18:35:49"),
  ("Whoopi","Moody","moody@google.com","2024-09-16 03:07:25"),
  ("Hall","Campbell","campbell2773@icloud.couk","2025-05-12 01:04:27"),
  ("Erin","Leonard","leonard742@aol.couk","2024-12-28 21:09:10"),
  ("Aurelia","Chambers","chambers@google.couk","2025-05-10 17:34:43"),
  ("Emi","Mosley","mosley@outlook.com","2025-07-23 18:05:43"),
  ("Avram","Reid","reid9270@yahoo.com","2024-09-29 02:03:02"),
  ("Kieran","Wilkerson","wilkerson@aol.ca","2025-08-03 19:23:26"),
  ("Virginia","Harrell","harrell1136@protonmail.couk","2025-03-17 11:48:46"),
  ("Price","Coffey","coffey@google.org","2025-07-30 04:23:58"),
  ("Oprah","Foster","foster8836@yahoo.org","2025-06-09 17:53:20"),
  ("Alexander","Norris","norris7290@aol.couk","2024-10-16 12:02:17"),
  ("Justine","Lamb","lamb9028@google.com","2025-08-09 12:34:59"),
  ("Ryder","Woodard","woodard3847@outlook.com","2025-06-02 11:04:11"),
  ("Baxter","Greer","greer3344@yahoo.net","2025-07-02 07:55:05"),
  ("Vielka","Allen","allen@google.com","2025-02-27 14:18:05"),
  ("Quin","Duncan","duncan3159@protonmail.ca","2024-09-27 01:41:55"),
  ("Beatrice","Tanner","tanner9459@outlook.com","2024-12-26 22:54:01"),
  ("Hunter","Moody","moody2661@outlook.com","2024-12-16 00:18:24"),
  ("Xanthus","Armstrong","armstrong@aol.edu","2024-11-09 22:05:30"),
  ("Mark","Green","green@protonmail.com","2025-07-17 11:37:10"),
  ("Colby","English","english@protonmail.couk","2024-12-16 23:53:08"),
  ("Alden","Dunlap","dunlap@hotmail.ca","2025-02-12 11:31:38"),
  ("Jessamine","Cortez","cortez@protonmail.couk","2025-08-04 22:58:22"),
  ("Wanda","Rogers","rogers@protonmail.couk","2025-01-27 05:50:13"),
  ("Reuben","Short","short7677@aol.couk","2024-09-26 00:06:29"),
  ("Mannix","Boyle","boyle2380@google.couk","2024-12-29 22:11:17"),
  ("Lunea","Vinson","vinson7713@hotmail.edu","2024-11-03 12:38:58"),
  ("Martina","Dixon","dixon6442@google.couk","2025-06-19 09:22:37"),
  ("Genevieve","Mcdonald","mcdonald485@aol.ca","2025-08-05 01:32:56"),
  ("Leslie","Jacobs","jacobs338@hotmail.org","2025-01-03 21:10:39"),
  ("Noel","Dyer","dyer8952@hotmail.net","2024-09-24 06:15:56"),
  ("Jesse","Leblanc","leblanc@aol.com","2025-06-20 00:09:01"),
  ("Michael","Kemp","kemp@aol.net","2024-10-12 04:48:32");