API tools faq
paste
Advertisement
diegocif

DB1

diegocif
Sep 7th, 2017
953
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 9.55 KB | None | 0 0
raw download clone embed print report
  1. DROP TABLE `TablaPrueba`;
  2.  
  3. CREATE TABLE `TablaPrueba` (
  4.   `ID_tabla` mediumint default NULL,
  5.   `Nombre` varchar(255) default NULL,
  6.   `Apellido` varchar(255) default NULL,
  7.   `Ciudad` varchar(255),
  8.   `Estrato` mediumint default NULL,
  9.   `Email` varchar(255) default NULL,
  10.   `Sexo` TEXT default NULL
  11. );
  12.  
  13. INSERT INTO `TablaPrueba` (`ID_tabla`,`Nombre`,`Apellido`,`Ciudad`,`Estrato`,`Email`,`Sexo`) VALUES (26,"Porter","Mccullough","Villenave-d'Ornon",1,"molestie.pharetra.nibh@turpis.co.uk","mollis. Phasellus"),(31,"Cain","Paul","Heppenheim",3,"ipsum.Donec@Aliquam.net","nec urna"),(92,"Samuel","Carlson","Lives-sur-Meuse",3,"ipsum.Phasellus@augue.net","nunc ac"),(22,"Macon","Stephens","Limoges",4,"adipiscing@magnaDuisdignissim.org","fringilla euismod"),(71,"Dieter","Mueller","Lennik",5,"pede.Nunc@Donecest.com","pede, nonummy"),(22,"Tanek","Mitchell","Newbury",1,"lectus.Nullam.suscipit@vestibulumneque.ca","lectus ante"),(31,"Kieran","Bray","Sachs Harbour",5,"amet.massa.Quisque@Duis.co.uk","dui. Cras"),(57,"Cedric","Rollins","Alva",4,"porttitor.scelerisque.neque@cursusvestibulumMauris.edu","quis lectus."),(72,"Bernard","Terrell","Loverval",4,"diam.nunc.ullamcorper@Curabiturconsequatlectus.net","lectus. Cum"),(47,"Oren","Gould","Tribogna",5,"sed.dui.Fusce@Utsemperpretium.edu","cursus purus.");
  14. INSERT INTO `TablaPrueba` (`ID_tabla`,`Nombre`,`Apellido`,`Ciudad`,`Estrato`,`Email`,`Sexo`) VALUES (62,"Nasim","Shelton","Medicine Hat",2,"diam.lorem.auctor@ornaresagittisfelis.co.uk","diam vel"),(43,"Stephen","Hayes","Broechem",1,"lorem@arcuet.ca","fringilla cursus"),(70,"Brett","Gonzalez","Siddi",3,"a.auctor.non@nonjustoProin.net","ipsum. Suspendisse"),(7,"Baker","Sharp","Bastia Umbra",5,"Mauris.vestibulum.neque@Etiambibendumfermentum.edu","ut dolor"),(94,"Benedict","Wilder","Senftenberg",2,"turpis.Nulla.aliquet@felis.org","eu neque"),(59,"Preston","Phillips","Silvan",4,"faucibus@et.net","diam at"),(18,"Cadman","Simon","Morro d'Alba",2,"Sed@quis.co.uk","a, aliquet"),(11,"Macaulay","Vargas","Berbroek",3,"orci.lacus.vestibulum@nonquamPellentesque.net","lorem lorem,"),(83,"Rashad","Sanders","Kooigem",5,"metus@sollicitudinorci.com","condimentum. Donec"),(5,"Castor","Albert","Aquila d'Arroscia",1,"nisl@et.ca","Sed congue,");
  15. INSERT INTO `TablaPrueba` (`ID_tabla`,`Nombre`,`Apellido`,`Ciudad`,`Estrato`,`Email`,`Sexo`) VALUES (93,"Jasper","Hensley","Thisnes",2,"augue.ut@magnatellusfaucibus.ca","Fusce dolor"),(8,"Oliver","Eaton","Kansas City",5,"Donec@Nunc.org","Donec sollicitudin"),(58,"Declan","Andrews","Sint-Denijs",4,"libero.lacus.varius@estacmattis.ca","per conubia"),(27,"Lucas","Burgess","Frederick",2,"et.magnis.dis@egestas.net","feugiat metus"),(4,"Judah","Walter","Drongen",4,"at@porttitor.org","Vestibulum accumsan"),(92,"Justin","Navarro","Portland",1,"Pellentesque.ultricies.dignissim@et.ca","vitae aliquam"),(55,"Edward","Haley","Zwickau",2,"dui.nec@eutellus.com","dolor vitae"),(69,"Kennedy","Gardner","Côte Saint-Luc",4,"nulla@Nuncpulvinar.co.uk","lectus pede"),(11,"Mufutau","Conner","Cortil-Noirmont",2,"sed@tellus.edu","ac, fermentum"),(71,"Graham","Gilbert","Solihull",3,"Praesent@et.ca","sit amet,");
  16. INSERT INTO `TablaPrueba` (`ID_tabla`,`Nombre`,`Apellido`,`Ciudad`,`Estrato`,`Email`,`Sexo`) VALUES (44,"Geoffrey","Mccarty","Bolzano/Bozen",4,"aptent.taciti@odioPhasellusat.edu","velit dui,"),(7,"Ira","Mccray","Penticton",1,"tincidunt.adipiscing.Mauris@felisullamcorper.com","massa. Vestibulum"),(6,"Ali","Reese","Hualaihué",2,"aliquet.magna.a@turpisnon.org","non enim"),(86,"Warren","Raymond","WanfercŽe-Baulet",2,"eget.venenatis@vulputatenisi.edu","Phasellus fermentum"),(11,"Orlando","Mosley","Sankt Ingbert",4,"sem.Nulla.interdum@Aliquamnecenim.co.uk","nunc ac"),(15,"Jerome","Haley","Pinneberg",2,"ligula.Aenean.euismod@necurna.co.uk","auctor non,"),(85,"Lev","Bennett","Bordeaux",5,"Etiam.ligula@semper.co.uk","scelerisque mollis."),(27,"Brendan","Scott","Multan",2,"Cras@Crasvulputate.co.uk","nulla. Integer"),(45,"Noble","Simon","Chattanooga",2,"Suspendisse@Phasellus.com","magna nec"),(21,"Kyle","Cook","Lafayette",4,"Suspendisse.sagittis@imperdiet.net","convallis ligula.");
  17. INSERT INTO `TablaPrueba` (`ID_tabla`,`Nombre`,`Apellido`,`Ciudad`,`Estrato`,`Email`,`Sexo`) VALUES (35,"Isaac","Whitfield","Geleen",1,"dictum@egetipsum.co.uk","sit amet,"),(28,"Gannon","Stephens","Hofheim am Taunus",1,"dolor.Nulla.semper@vitaesemperegestas.org","tellus justo"),(33,"Eaton","Mckee","Villers-Perwin",5,"adipiscing.elit@Nulladignissim.ca","turpis. Aliquam"),(57,"Barrett","Richmond","Clarksville",2,"orci@at.org","nulla magna,"),(39,"Zachary","Mcfarland","Orciano Pisano",1,"orci.luctus@aliquam.org","semper pretium"),(36,"Declan","Whitehead","Barbania",2,"suscipit@cursus.co.uk","tincidunt pede"),(35,"Colorado","Maynard","Neu-Isenburg",4,"eget.metus@risusDonec.co.uk","ac urna."),(92,"Zephania","Hess","Alix",1,"lacus.Quisque.purus@libero.org","enim, sit"),(13,"Melvin","Wiggins","Colwood",1,"vel.quam@at.net","sagittis. Duis"),(88,"Ahmed","Sweeney","Corbara",5,"Ut.tincidunt@Quisque.org","purus sapien,");
  18. INSERT INTO `TablaPrueba` (`ID_tabla`,`Nombre`,`Apellido`,`Ciudad`,`Estrato`,`Email`,`Sexo`) VALUES (80,"Tanek","Lawson","Palanzano",3,"diam@molestiepharetranibh.org","Aliquam fringilla"),(6,"Tanek","Kline","Sars-la-Buissire",2,"neque.tellus.imperdiet@dictumauguemalesuada.edu","diam. Sed"),(34,"Zahir","Miller","Bridgeport",3,"justo@felisullamcorper.edu","mattis ornare,"),(59,"Felix","Mcclain","Potsdam",3,"Donec@accumsan.ca","elit. Nulla"),(41,"Hayes","Goodman","Terzorio",3,"erat.Sed.nunc@tortor.net","blandit at,"),(41,"Paul","Chapman","Cariboo Regional District",5,"massa.Integer.vitae@quisaccumsanconvallis.org","pulvinar arcu"),(84,"Sawyer","Stein","Silvassa",3,"lectus@Vivamus.org","ante dictum"),(78,"Judah","Bowman","Rivière-du-Loup",3,"ut.aliquam@Vivamuseuismodurna.co.uk","primis in"),(69,"Beck","Fuller","Laakirchen",2,"Mauris.vestibulum@liberomauris.com","amet diam"),(31,"Christian","Jacobs","Welland",4,"placerat.eget.venenatis@pellentesqueSed.net","nibh. Quisque");
  19. INSERT INTO `TablaPrueba` (`ID_tabla`,`Nombre`,`Apellido`,`Ciudad`,`Estrato`,`Email`,`Sexo`) VALUES (10,"Austin","Bentley","Oberwart",5,"mi.Duis@diam.com","nunc sed"),(79,"Jarrod","Cunningham","Didim",3,"convallis@Nam.ca","amet risus."),(44,"Jesse","Rowe","Calco",2,"montes.nascetur@Fuscefermentumfermentum.com","posuere at,"),(1,"Nissim","Mcknight","Porirua",4,"purus@sitamet.com","primis in"),(17,"Deacon","Weaver","Piegaro",3,"eu.ultrices@variusNam.org","per inceptos"),(88,"Tad","Langley","Melsele",1,"Donec@luctusfelis.org","risus a"),(49,"Clayton","Roberson","Fossato Serralta",2,"sagittis.placerat@ante.net","diam. Pellentesque"),(3,"Chaim","Mack","Bad Oldesloe",1,"euismod.est.arcu@Loremipsum.ca","diam. Pellentesque"),(93,"Elijah","Burke","New Sarepta",4,"enim.nisl@fermentum.org","Nullam vitae"),(20,"Ferris","Cannon","Brodick",4,"Donec@inconsectetueripsum.co.uk","convallis dolor.");
  20. INSERT INTO `TablaPrueba` (`ID_tabla`,`Nombre`,`Apellido`,`Ciudad`,`Estrato`,`Email`,`Sexo`) VALUES (86,"Levi","Bartlett","Zaragoza",2,"Nunc@amet.net","odio semper"),(31,"Griffith","Sloan","Dworp",3,"aliquet.vel.vulputate@suscipitest.co.uk","Donec non"),(70,"Martin","Serrano","Barrhead",5,"in@Nullamsuscipitest.co.uk","magnis dis"),(95,"Fritz","Abbott","Florida",1,"facilisis.lorem@Nullamfeugiatplacerat.co.uk","cubilia Curae;"),(79,"Allen","Pitts","Monte San Pietrangeli",5,"feugiat@SeddictumProin.org","facilisi. Sed"),(58,"Demetrius","Tyler","Rekem",4,"fermentum.metus.Aenean@Donec.org","Quisque purus"),(70,"Marsden","Tucker","Hofstade",2,"sem.ut.dolor@aliquetvel.org","Suspendisse sagittis."),(6,"Thomas","Nelson","Tirúa",2,"Aenean.gravida.nunc@nisi.co.uk","fames ac"),(79,"Jackson","Gates","Waiblingen",5,"convallis.ligula.Donec@malesuada.edu","diam luctus"),(2,"Jackson","Landry","Sromness",5,"urna.convallis@etnetus.com","orci lobortis");
  21. INSERT INTO `TablaPrueba` (`ID_tabla`,`Nombre`,`Apellido`,`Ciudad`,`Estrato`,`Email`,`Sexo`) VALUES (96,"Uriah","Warner","Cimitile",2,"Morbi.sit@iaculis.org","sed, est."),(21,"Owen","Guthrie","Santander",4,"adipiscing.fringilla.porttitor@malesuadaInteger.edu","ipsum leo"),(49,"Tanek","Jarvis","Cavallino",1,"tellus.eu@actellusSuspendisse.org","urna. Ut"),(55,"Dylan","Figueroa","Llangollen",1,"auctor.odio@nec.co.uk","dapibus gravida."),(36,"Nigel","Banks","Kirkcaldy",3,"ipsum@liberoInteger.org","ac facilisis"),(69,"Dieter","Nielsen","Rutland",1,"natoque.penatibus.et@ligula.edu","tellus. Nunc"),(23,"Igor","Thomas","Municipal District",1,"nulla.ante@aliquetmetus.co.uk","at lacus."),(35,"Cade","Waters","Hengelo",1,"nisi.Cum.sociis@tempuslorem.net","nec ante."),(87,"Leonard","Dillard","Bicinicco",1,"id.blandit.at@imperdietornareIn.com","neque sed"),(19,"Fulton","Clemons","White Rock",5,"turpis.Nulla@ridiculusmusAenean.co.uk","leo elementum");
  22. INSERT INTO `TablaPrueba` (`ID_tabla`,`Nombre`,`Apellido`,`Ciudad`,`Estrato`,`Email`,`Sexo`) VALUES (6,"Elvis","Bray","Wrexham",1,"euismod.est@Nuncut.net","Donec vitae"),(9,"Honorato","Sloan","Gjoa Haven",1,"ut.lacus@nequeIn.ca","elit elit"),(2,"Jason","Fernandez","Northumberland",1,"dolor.nonummy@elementumat.edu","Mauris vestibulum,"),(24,"Keefe","Suarez","Clare",2,"tempus@ullamcorpereu.co.uk","quam dignissim"),(45,"Nissim","Lamb","Francofonte",2,"egestas@Donecatarcu.org","mollis vitae,"),(73,"Harper","Porter","Shawville",5,"ad.litora.torquent@auctorvitaealiquet.ca","lacus vestibulum"),(43,"Brent","Kim","Widooie",4,"egestas.ligula@hymenaeosMaurisut.edu","Curabitur vel"),(73,"Uriel","Foley","Port Moody",2,"parturient@Duis.com","placerat eget,"),(47,"Walker","Lambert","Doetinchem",2,"Vivamus@ullamcorperDuiscursus.net","Class aptent"),(20,"Omar","Vaughn","Fort St. John",3,"odio.a.purus@aliquamenim.com","enim. Sed");
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!