Last active
September 1, 2025 00:05
-
-
Save kurotori/b5b8507711cd5b5dae5ffd4b0035b645 to your computer and use it in GitHub Desktop.
Programación 2: Base de Datos con datos de ejemplo
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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"); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment