sql

CREATE TABLE `mahasiswa`(
    `nim` MEDIUMINT DEFAULT NULL,
    `nama` VARCHAR(255) DEFAULT NULL,
    `alamat` VARCHAR(255) DEFAULT NULL,
    `email` VARCHAR(255) DEFAULT NULL,
    PRIMARY KEY(`nim`)
) AUTO_INCREMENT = 1; INSERT INTO `mahasiswa`(`nim`, `nama`, `alamat`, `email`)
VALUES(
    3548,
    "Brendan Melendez",
    "740-3306 Curabitur Street",
    "Sed@SednequeSed.edu"
),(
    3573,
    "Malik Velasquez",
    "Ap #725-500 Aliquam Avenue",
    "vehicula@rutrumeuultrices.com"
),(
    3916,
    "Stone Terry",
    "166-2393 Erat. Av.",
    "ligula@etnetuset.co.uk"
),(
    4827,
    "Lawrence Nicholson",
    "162-6167 Elit, Ave",
    "consectetuer.adipiscing@Donecest.com"
),(
    2166,
    "Reece Sampson",
    "5374 Mi Av.",
    "tellus.Phasellus.elit@venenatisvel.ca"
),(
    3255,
    "Coby Alexander",
    "Ap #911-4198 Sociis St.",
    "arcu.vel.quam@pedeblandit.com"
),(
    4019,
    "Preston Bullock",
    "932-1022 Consequat St.",
    "est.ac.mattis@fermentumconvallis.net"
),(
    2873,
    "Mark Park",
    "P.O. Box 100, 7498 Gravida Ave",
    "purus@orci.org"
),(
    1579,
    "Forrest Winters",
    "977-7044 Eleifend Av.",
    "hendrerit.a@ami.edu"
),(
    2428,
    "Shad Vaughan",
    "107-9426 Mi Street",
    "magna.Lorem@vitaesodalesnisi.net"
);
INSERT INTO `mahasiswa`(`nim`, `nama`, `alamat`, `email`)
VALUES(
    2044,
    "Caleb Bright",
    "7723 Feugiat. Rd.",
    "et@Sedauctor.com"
),(
    4311,
    "Hamish Harper",
    "Ap #835-4520 Risus, Road",
    "Aenean.massa.Integer@necligulaconsectetuer.edu"
),(
    3567,
    "Lucian Howell",
    "293-809 Rutrum Av.",
    "sit.amet@dignissimmagnaa.edu"
),(
    1699,
    "Maxwell Whitehead",
    "544-1643 Massa Ave",
    "Cras.vehicula.aliquet@etnetus.com"
),(
    4545,
    "Francis Carver",
    "P.O. Box 475, 2849 Ut Road",
    "metus@ametconsectetueradipiscing.co.uk"
),(
    2080,
    "Cooper Wong",
    "P.O. Box 339, 5719 Diam. Street",
    "nec.mauris@Donecsollicitudin.edu"
),(
    2913,
    "Lance Marquez",
    "4382 Nec Avenue",
    "egestas@mauris.com"
),(
    4890,
    "Abel Waller",
    "P.O. Box 592, 3127 Aliquet Ave",
    "nunc.est@arcu.edu"
),(
    1905,
    "Adam Oneil",
    "6443 Tellus Av.",
    "congue.turpis.In@dapibusligula.ca"
),(
    2703,
    "Daquan Rowe",
    "204-9041 Ante. Ave",
    "magna.et.ipsum@Morbi.com"
);
INSERT INTO `mahasiswa`(`nim`, `nama`, `alamat`, `email`)
VALUES(
    2664,
    "Dolan Cortez",
    "6023 Erat Av.",
    "pede.Cras@egetvolutpatornare.co.uk"
),(
    3578,
    "Garth Little",
    "3393 Lacinia. Street",
    "in@ullamcorperviverra.net"
),(
    1968,
    "Macaulay Ruiz",
    "P.O. Box 611, 7021 Ridiculus Rd.",
    "Cras@lacus.co.uk"
),(
    4880,
    "Jared Cook",
    "Ap #391-9835 Pellentesque Avenue",
    "fringilla.est@rutrum.edu"
),(
    1345,
    "Mark Hyde",
    "251-8378 Sed Av.",
    "eu.tellus.eu@a.net"
),(
    4828,
    "Kane Wilder",
    "P.O. Box 484, 3335 Quisque Rd.",
    "dui.Fusce@egetipsum.edu"
),(
    2402,
    "Zachery Hays",
    "P.O. Box 484, 9998 Gravida St.",
    "rutrum.justo@molestie.net"
),(
    1957,
    "Bruno Valencia",
    "771-8208 Facilisis, Rd.",
    "auctor.velit.Aliquam@tristiquesenectus.co.uk"
),(
    2562,
    "Jasper Cochran",
    "Ap #763-7211 Est Road",
    "imperdiet.non.vestibulum@ridiculusmus.org"
),(
    2409,
    "Aristotle Alford",
    "4872 Eget Av.",
    "quis@quispedePraesent.org"
);
INSERT INTO `mahasiswa`(`nim`, `nama`, `alamat`, `email`)
VALUES(
    2701,
    "Derek Kirk",
    "8529 Nibh Road",
    "tortor@neque.org"
),(
    2387,
    "Francis Bates",
    "Ap #356-2015 Lobortis Street",
    "ultricies.sem.magna@estNunc.edu"
),(
    2899,
    "Laith Alston",
    "147-9660 Posuere Avenue",
    "amet.consectetuer@Craslorem.net"
),(
    3115,
    "Troy Avery",
    "P.O. Box 840, 4867 Volutpat St.",
    "pede.Nunc@tinciduntvehicula.co.uk"
),(
    2973,
    "Igor Daniel",
    "Ap #877-2048 Ante. St.",
    "dui.Cum@non.co.uk"
),(
    3147,
    "Darius Randall",
    "Ap #675-6092 Mauris Road",
    "cursus.non.egestas@tellusPhasellus.org"
),(
    1964,
    "Gregory Kirby",
    "Ap #630-8952 Ut St.",
    "mi@nunc.net"
),(
    2704,
    "Stephen Welch",
    "P.O. Box 293, 1736 Ornare St.",
    "dolor.Fusce.feugiat@mi.org"
),(
    3383,
    "Keefe Bishop",
    "2838 Integer Avenue",
    "Cras.lorem@Nuncmauriselit.net"
),(
    4449,
    "Raja Keith",
    "2424 Accumsan Ave",
    "id.ante.Nunc@rutrum.ca"
);
INSERT INTO `mahasiswa`(`nim`, `nama`, `alamat`, `email`)
VALUES(
    3923,
    "Melvin Griffin",
    "281-3515 Risus. St.",
    "auctor.velit.eget@nisidictum.net"
),(
    3851,
    "Barrett Robbins",
    "Ap #408-5384 Integer Street",
    "sem@Aliquam.net"
),(
    3413,
    "Finn Roman",
    "Ap #258-5248 Penatibus Av.",
    "sed.consequat.auctor@diamdictumsapien.edu"
),(
    4167,
    "Hayes Buckner",
    "865-7220 Elit, Av.",
    "arcu@ascelerisquesed.edu"
),(
    3486,
    "Eaton Burgess",
    "4726 Senectus St.",
    "Mauris.ut.quam@euneque.co.uk"
),(
    1151,
    "Benjamin Neal",
    "690-7041 Egestas Street",
    "dis.parturient@sollicitudinamalesuada.com"
),(
    1898,
    "Brody Gamble",
    "Ap #982-3539 Risus. St.",
    "consectetuer.adipiscing@lectus.com"
),(
    3144,
    "Wade George",
    "P.O. Box 496, 3957 Nunc Rd.",
    "dictum.cursus@aliquet.org"
),(
    2933,
    "Caldwell Adams",
    "P.O. Box 229, 6221 Imperdiet Av.",
    "Cras@iaculisenim.net"
),(
    4446,
    "Jameson Bruce",
    "6490 Vivamus Rd.",
    "montes.nascetur.ridiculus@nequeet.co.uk"
);
INSERT INTO `mahasiswa`(`nim`, `nama`, `alamat`, `email`)
VALUES(
    2382,
    "Carlos Marks",
    "P.O. Box 388, 8659 Euismod St.",
    "felis.eget@enimEtiamimperdiet.edu"
),(
    4431,
    "Hyatt Barr",
    "8193 Aliquam Rd.",
    "eu@at.ca"
),(
    1477,
    "Drake Durham",
    "7088 Sociis Rd.",
    "nascetur@euenimEtiam.org"
),(
    1973,
    "Barrett Thornton",
    "9129 Nec Avenue",
    "mauris@at.com"
),(
    4609,
    "Brennan Walsh",
    "8197 Eget Rd.",
    "Aliquam.adipiscing@dictum.net"
),(
    4463,
    "Lucius Mcconnell",
    "Ap #634-7244 Posuere Avenue",
    "Etiam.bibendum.fermentum@etrisus.co.uk"
),(
    1067,
    "Forrest Ellison",
    "Ap #623-8534 Lectus, Av.",
    "pulvinar.arcu.et@est.co.uk"
),(
    1045,
    "Kirk Berg",
    "351-6266 Vestibulum, Rd.",
    "non.hendrerit@anunc.co.uk"
),(
    3794,
    "Fuller Mccarty",
    "4201 Lobortis Street",
    "urna.Ut@egetvolutpat.ca"
),(
    4212,
    "Francis Combs",
    "Ap #713-2314 Nunc Rd.",
    "nisi.dictum@sedpede.org"
);
INSERT INTO `mahasiswa`(`nim`, `nama`, `alamat`, `email`)
VALUES(
    3998,
    "Valentine Farrell",
    "6916 Cras St.",
    "velit.Sed@Crasdolor.ca"
),(
    3247,
    "Dieter Stevenson",
    "883-2007 Sociis Rd.",
    "Aliquam.tincidunt@nasceturridiculusmus.net"
),(
    2589,
    "Erasmus Sharpe",
    "Ap #810-1632 Mi Avenue",
    "diam.at.pretium@interdumenimnon.com"
),(
    2912,
    "Lionel Hewitt",
    "881-2406 Congue, St.",
    "habitant.morbi.tristique@Maurisnulla.ca"
),(
    4589,
    "Patrick Russell",
    "P.O. Box 289, 8923 Amet, St.",
    "orci.lacus@musProinvel.com"
),(
    1876,
    "Laith Robles",
    "P.O. Box 237, 4134 Vitae Street",
    "sodales.elit@magnis.net"
),(
    4853,
    "Roth Reeves",
    "234-9035 Tincidunt Ave",
    "sed.pede.nec@nectempusscelerisque.edu"
),(
    2346,
    "Kirk Peters",
    "143-6547 Velit. St.",
    "tortor.Nunc@dapibusid.net"
),(
    1099,
    "Rogan Graham",
    "Ap #214-2176 Mi. Street",
    "ultricies.ornare.elit@pedenonummy.net"
),(
    3136,
    "Octavius Harvey",
    "P.O. Box 725, 2375 Mauris Ave",
    "Mauris.non@risus.net"
);
INSERT INTO `mahasiswa`(`nim`, `nama`, `alamat`, `email`)
VALUES(
    4105,
    "Barrett Gutierrez",
    "547-1628 Turpis Av.",
    "vel@Vestibulumaccumsanneque.com"
),(
    4722,
    "Travis Mccarthy",
    "P.O. Box 701, 5597 Amet Road",
    "Pellentesque.ut@nonmagna.net"
),(
    3273,
    "Wing Pruitt",
    "Ap #576-3100 Nonummy St.",
    "Aliquam@etrutrum.edu"
),(
    1623,
    "Kadeem Levy",
    "Ap #158-2317 Quam, Av.",
    "elit@Aliquam.co.uk"
),(
    1331,
    "Cedric Strong",
    "8405 Duis Street",
    "Curabitur@maurisIntegersem.co.uk"
),(
    2073,
    "Gareth Bean",
    "Ap #704-2359 Quam. St.",
    "montes.nascetur@velitAliquamnisl.org"
),(
    2837,
    "Bevis Hyde",
    "958 Et, Road",
    "ut.molestie@nondui.ca"
),(
    4939,
    "Oren Terrell",
    "8300 Posuere Ave",
    "velit.Sed@Suspendisseseddolor.edu"
),(
    4012,
    "Camden Alvarez",
    "2268 Egestas St.",
    "nonummy.ac.feugiat@utaliquamiaculis.edu"
),(
    4694,
    "Oscar Watts",
    "P.O. Box 253, 6662 Sagittis. Rd.",
    "diam.luctus.lobortis@justo.org"
);
INSERT INTO `mahasiswa`(`nim`, `nama`, `alamat`, `email`)
VALUES(
    4981,
    "Rashad Warren",
    "9279 Interdum Road",
    "sollicitudin.orci.sem@a.ca"
),(
    4833,
    "Luke Erickson",
    "Ap #445-1986 Sociis Rd.",
    "quis@convallis.com"
),(
    3015,
    "Tyler Miles",
    "P.O. Box 332, 172 Et Rd.",
    "amet@egetmetus.net"
),(
    1484,
    "Scott Baxter",
    "Ap #909-1820 Eu Road",
    "vitae@utlacus.ca"
),(
    3651,
    "Len Hansen",
    "Ap #417-8492 Tempus Av.",
    "nunc@idmollisnec.co.uk"
),(
    2268,
    "Channing Sherman",
    "P.O. Box 876, 3243 Aenean Av.",
    "est.Mauris.eu@Morbi.net"
),(
    4855,
    "Dustin Maldonado",
    "Ap #444-9098 Eleifend Street",
    "orci@aclibero.ca"
),(
    4301,
    "Dexter Roberson",
    "7267 Et Av.",
    "non.luctus.sit@utodiovel.ca"
),(
    4346,
    "Prescott Rivera",
    "398-3048 Risus. Street",
    "iaculis.quis.pede@arcu.co.uk"
),(
    1602,
    "Thaddeus Tyler",
    "P.O. Box 610, 282 Sed Avenue",
    "dolor.Quisque@dolor.org"
);
INSERT INTO `mahasiswa`(`nim`, `nama`, `alamat`, `email`)
VALUES(
    1780,
    "Sawyer Slater",
    "128-1032 Turpis Rd.",
    "malesuada@vitae.co.uk"
),(
    3592,
    "Curran Pace",
    "Ap #284-5239 Phasellus Rd.",
    "sed@CuraeDonectincidunt.co.uk"
),(
    3869,
    "Barclay Allison",
    "522-9814 Amet Rd.",
    "massa@nibh.com"
),(
    1295,
    "Bernard Briggs",
    "P.O. Box 635, 7086 Proin Ave",
    "magnis.dis.parturient@dolorvitae.net"
),(
    4772,
    "Logan Frazier",
    "Ap #168-8950 Magna. St.",
    "rutrum.non.hendrerit@nisiCum.ca"
),(
    4942,
    "Sylvester Mccarthy",
    "P.O. Box 877, 3646 Cras Ave",
    "aliquet@odio.com"
),(
    1929,
    "Isaac Boyle",
    "583-8113 Tortor. Av.",
    "aliquam.adipiscing.lacus@Duisac.co.uk"
),(
    1873,
    "Ulric Cohen",
    "P.O. Box 236, 6741 Vitae, Av.",
    "urna@dictumplacerataugue.com"
),(
    1025,
    "Aidan Hodges",
    "Ap #927-7865 Diam. St.",
    "ipsum.primis.in@liberoestcongue.ca"
),(
    1208,
    "George Leon",
    "Ap #740-4798 Volutpat. St.",
    "velit.Aliquam.nisl@lobortisquama.co.uk"
);