-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathinsert many data.sql
9 lines (7 loc) · 5.95 KB
/
insert many data.sql
1
2
3
4
5
6
7
8
9
-- INSERT INTO personal(id,name,birth_date,phone,gender)
-- VALUES
-- (2,"Meera","1991-03-10","1234567890","F"),
-- (3,"Anil kapoor","1981-05-10","098765412","M"),
-- (4,"John Abraham","1951-12-15","08826558412","M"),
-- (5,"JJuhi","2000-12-15","08826558412","F")
INSERT INTO `Exam` VALUES (0,'Prof. Tessie Mertz',2622,3,'M','092.396.9427','West Cierraland'),(1,'Ms. Ella Stiedemann',0,1,'D','1-044-086-23','Port Halle'),(2,'Gracie Bailey',43967,6,'P','(074)574-837','Lillieshire'),(3,'Cornelius Smitham',522653,8,'M','1-087-410-59','New Christopher'),(4,'Drew Ankunding',208687,8,'M','205.100.9565','Osinskiview'),(5,'Jess O\'Reilly',414893,1,'D','146.060.4209','Dickiborough'),(6,'Delbert Stracke',4686,3,'P','229-665-5848','Port Dennisstad'),(8,'Ms. Beth Gulgowski',277100378,8,'M','1-832-685-37','Franeckiport'),(12,'Mr. Rafael Grady IV',19252695,6,'M','06372314186','Port Morganborough'),(14,'Laurine Cronin',2242,7,'M','+16(4)402049','Spencerfurt'),(36,'Dawn Bode MD',136719,4,'M','363.551.0232','Adrianastad'),(39,'Brice Murray',78012,6,'D','(867)237-321','East Jamil'),(47,'Judy Rippin',0,5,'D','1-927-713-68','Ceciliamouth'),(56,'Collin Pouros II',38382356,4,'M','423.980.1953','New Enolastad'),(58,'Prof. Tiana Swaniawski DDS',18947544,3,'M','1-523-361-57','Port Meggie'),(68,'Domenica Wilderman',0,8,'P','284-543-6362','Dorthatown'),(83,'Adele Ratke',244,2,'P','026-488-4222','Lionelland'),(91,'Antwon Crooks',0,7,'M','06783914362','Port Issacton'),(130,'Gillian Prohaska',35000,4,'M','(359)672-228','Swiftshire'),(155,'Adolphus Rowe',305,7,'M','661-430-9637','Willstad'),(175,'Sandy Barton',1,3,'M','789-146-1214','South Melany'),(189,'Ms. Minerva Lowe',44945363,4,'M','(376)549-826','Marjoryfurt'),(269,'Karley Bins II',0,6,'M','023-175-0703','East Vivianneburgh'),(284,'Tobin Keebler',2302588,5,'P','(265)356-552','South Tyreekton'),(298,'Dr. Rickey Sauer V',501850,6,'P','940-114-5990','Aniyahbury'),(301,'Prof. Cade Bergstrom',2123684,2,'D','04846945696','West Dudley'),(388,'Ernestine Fay',0,6,'P','05166991662','Forresttown'),(467,'Ralph Wisozk',0,3,'M','624-789-0846','Hyattfurt'),(609,'Zelda Bins',38,2,'M','615.725.6391','Madisynville'),(691,'Tressa Schmeler',199994,2,'P','527-544-0765','East Vince'),(3343,'Stacey Zieme',2,2,'M','1-694-894-67','West Allenland'),(3766,'Delia Frami Jr.',0,4,'M','(518)965-962','West Hershelmouth'),(5720,'Litzy Paucek PhD',0,5,'D','(912)527-343','Griffintown'),(6236,'Jarrell Huels Jr.',59,7,'P','+42(4)193260','Dickinsonland'),(7019,'Felipe Wuckert',13,6,'M','(726)261-661','East Charity'),(7883,'Keegan Torp III',1403,5,'P','+02(8)219024','New Martinberg'),(10332,'Aliza Toy IV',35704812,7,'D','241-958-0378','New Jazlynfurt'),(11955,'Lew Yost',0,5,'M','05757334841','Port Gunnarstad'),(12742,'Celine Towne',138737,6,'P','(206)409-188','Wittingstad'),(17774,'Margie Macejkovic Sr.',34,2,'D','(786)945-327','North Guadalupe'),(25133,'Joana Conn',28773,1,'M','131.688.9460','North Linnie'),(60293,'Amaya Abernathy',5665818,9,'M','222.025.9837','Ovaberg'),(66402,'Dr. Kole Sanford PhD',18,1,'P','(261)439-197','Koelpinmouth'),(69863,'Lincoln Schoen',6982106,8,'D','(926)296-709','Port Madelynborough'),(80372,'Annabelle Kuphal',0,2,'D','+03(4)630965','Edwinabury'),(117423,'Dr. Mireya Brekke',1,6,'M','1-503-508-83','Ullrichburgh'),(140957,'Nyasia Aufderhar',36462,7,'M','871.103.4506','North Majorview'),(149151,'Helena Gleason',5,2,'M','(647)382-168','Batztown'),(183987,'Marta Armstrong',0,6,'P','200-393-1839','North Celestinotown'),(223967,'Kasandra Trantow Sr.',4698598,5,'M','119-317-4864','Pfannerstillland'),(265138,'Dr. Shad Farrell',832,1,'M','636.310.8363','Port Aliyastad'),(265614,'Dr. Bridgette Lindgren',51803130,3,'M','1-775-275-86','North Shanelberg'),(576709,'Ronaldo Torp',203,9,'D','508.230.4602','Cornellhaven'),(944867,'Donnell Wehner',215,5,'P','(272)621-953','Sidneyport'),(1211422,'Dr. Genevieve Beer DDS',50765,7,'D','635-486-4717','Stokesview'),(1604546,'Dr. Zoe Jerde',139850153,1,'P','688.447.1395','Strackeville'),(2003842,'Dr. Michaela Nikolaus IV',2019264,1,'D','1-583-021-39','Jacobihaven'),(2184885,'Mr. Trey Padberg V',35420065,4,'D','+04(8)501781','Maggiostad'),(2503571,'Kaley Wintheiser DDS',258794,4,'M','1-214-791-36','Wildermanview'),(2960524,'Nicolette Bogisich II',437212597,7,'M','01251316287','Lake Neldaville'),(5844503,'Ransom Abernathy',797634,5,'M','310.663.6713','West Ayden'),(5950869,'Beaulah Wisozk I',2478,8,'M','102-969-6438','Keelingshire'),(6101781,'Ernestina Nolan',1129425,1,'P','03513501492','New Trinity'),(6294353,'Margarete Schimmel',144349224,2,'M','1-277-716-17','East Rettatown'),(6428737,'Marian Rice',1748886,8,'D','02642167938','East Bradybury'),(7551576,'Luther Hintz',91,7,'D','03492207328','Stiedemannfort'),(8527760,'Dr. Vance Kovacek',68,7,'D','655-614-9122','West Jerrold'),(10481847,'Ms. Valentine Marquardt II',6066,8,'M','(018)075-374','Port Tina'),(12322591,'Alvena Considine',96,7,'M','028-028-3310','South Blakeberg'),(12325337,'Mrs. Jackie Klocko DVM',231,5,'M','792-889-1139','Lialand'),(23562004,'Raymond Block',55641060,4,'M','119-943-5821','Port Laronport'),(25567592,'Ms. Jackeline Dickens IV',2472665,7,'P','414-331-2769','South Colemanmouth'),(26358828,'Colt Ratke',124328,2,'D','1-175-467-89','Hintzfurt'),(28626251,'Jonathan Bogan',440350539,5,'M','(919)319-957','East Mattieton'),(29175879,'Dr. Jaeden Wisoky DDS',1,4,'D','1-637-235-11','McDermottberg'),(36309316,'Dr. Theodora White',0,9,'D','(981)143-228','Maureenshire'),(40474557,'Mrs. Courtney Hane MD',303026,8,'P','853-738-6784','Zboncakstad'),(51469862,'Adan McDermott II',0,2,'P','087.618.4809','Kemmermouth'),(63415365,'Wayne Bartell',801043,9,'D','+47(2)182388','Hilllshire'),(85774642,'Michale Koelpin',0,1,'D','+82(0)204697','Port Wardview'),(149832290,'Prof. Jaiden Haag Jr.',138,8,'M','753-593-7408','Meggiefort'),(359487763,'Mrs. Era Toy I',0,6,'P','450.772.5981','Vonside'),(359722555,'Ms. Audie Huels DVM',143004,7,'D','(778)797-277','Hintzfurt'),(382712861,'Jewell Boyle',6,1,'M','1-118-800-22','South Fritzland'),(670231164,'Mable Borer',796,6,'M','(315)668-234','South Ruth');