使用Mockaroo生成测试数据

雪域迷影

已于 2024-10-12 23:32:02 修改

阅读量830

点赞数 5

分类专栏： SpringBoot和VueJs学习数据库技术软件使用文章标签： java springboot mockdata

于 2024-10-12 23:19:54 首次发布

本文链接：https://blog.csdn.net/ccf19881030/article/details/142889691

版权

使用Mockaroo生成测试数据

最近在学习【Spring Boot & React】Spring Boot和React教程视频的P51.Generating 1000 students一课中，看到了https://www.mockaroo.com/网站可以用来模拟生成测试数据，觉得还不错，特此记录一下。感觉每次看老外的计算机技术视频，总是能够带给我们惊喜。
在我们实际编程中，有时候需要自己mock一些测试数据用于测试，比如说往数据库student中放一些测试数据，有这个一个网站：https://www.mockaroo.com/可以满足我们的需要，它可以帮助我们生成1000行实际的测试数据，有CSV、JSON、SQL和Excel格式。如下图所示：

mockaroo网站
假如我们在SpringBoot中有这么一张表，表结构如下所示：

amigoscodedb=# \d student;
                      Table "public.student"
 Column |          Type          | Collation | Nullable | Default
--------+------------------------+-----------+----------+---------
 id     | bigint                 |           | not null |
 email  | character varying(255) |           |          |
 gender | character varying(255) |           |          |
 name   | character varying(255) |           |          |
Indexes:
    "student_pkey" PRIMARY KEY, btree (id)
Check constraints:
    "student_gender_check" CHECK (gender::text = ANY (ARRAY['MALE'::character varying, 'FEMALE'::character varying]::text[]))

对应的Java Student实体类代码为：

package com.amigoscode.demo.student;

import com.fasterxml.jackson.annotation.JsonAnyGetter;
import jakarta.persistence.*;
import lombok.*;

import java.util.UUID;

@ToString
@Getter
@Setter
@EqualsAndHashCode
@NoArgsConstructor
@AllArgsConstructor
@Entity
@Table
public class Student {
   
    @Id
    @SequenceGenerator(
            name = "student_sequence",
            sequenceName = "student_sequence",
            allocationSize = 1
    )
    @GeneratedValue(
            generator = "student_sequence",
            strategy = GenerationType.SEQUENCE)
    private Long id;
    private String name;
    private String email;
    @Enumerated(EnumType.STRING)
    private Gender gender;

    public Student(String name, String email, Gender gender) {
   
        this.name = name;
        this.email = email;
        this.gender = gender;
    }
}

我们想生成1000行student表的数据，可以在https://www.mockaroo.com/网站中根据字段生成对应的1000行数据。

根据表格字段定义数据

Format 数据格式

利用https://www.mockaroo.com/网站，我们可以生成CSV、JSON、Tab-Delimited、SQL、Firebase、Excel、XML等常用的数据格式，如下图所示：
Format

Formula 公式

其中点击字段后面的图标可以将数据加1，将数据全部大写或者小写，或者按照自己的逻辑去处理原始数据，如下图所示：
Formula
另外我们想要对gender性别字段大写，取值有Female和Male转换成大写格式，可以在对应的gender字段的Formula公式输入框中输入upper(this)进行转换 gender字段
公式将gender性别字段转换成大写格式
填好字段的数据类型和字段，表格名称之后，我们点击PREVIEW按钮就可以生成我们的数据，如下图所示：
预览数据
我们也可以直接点击GENERATE DATA按钮生成1000行数据，其中的一个样本数据如下：

insert into student (id, name, email, gender) values (1, 'Ransom Pharo', 'rpharo0@dedecms.com', 'MALE');
insert into student (id, name, email, gender) values (2, 'Gottfried Fewster', 'gfewster1@google.co.uk', 'MALE');
insert into student (id, name, email, gender) values (3, 'Jonah De la Harpe', 'jde2@businessweek.com', 'MALE');
insert into student (id, name, email, gender) values (4, 'Cristi Full', 'cfull3@mapy.cz', 'FEMALE');
insert into student (id, name, email, gender) values (5, 'Ty Liebermann', 'tliebermann4@dropbox.com', 'MALE');
insert into student (id, name, email, gender) values (6, 'Any Sexti', 'asexti5@a8.net', 'MALE');
insert into student (id, name, email, gender) values (7, 'Vinita Lowndesbrough', 'vlowndesbrough6@illinois.edu', 'FEMALE');
insert into student (id, name, email, gender) values (8, 'Justinian Munt', 'jmunt7@weibo.com', 'MALE');
insert into student (id, name, email, gender) values (9, 'Marrilee Attewill', 'mattewill8@google.com.br', 'FEMALE');
insert into student (id, name, email, gender) values (10, 'Ashbey Paybody', 'apaybody9@tiny.cc', 'MALE');
insert into student (id, name, email, gender) values (11, 'Michel Penhale', 'mpenhalea@spotify.com', 'FEMALE');
insert into student (id, name, email, gender) values (12, 'Agnes Ekell', 'aekellb@seattletimes.com', 'FEMALE');
insert into student (id, name, email, gender) values (13, 'Holly Fremantle', 'hfremantlec@forbes.com', 'MALE');
insert into student (id, name, email, gender) values (14, 'Stavros Lieber', 'slieberd@ebay.co.uk', 'MALE');
insert into student (id, name, email, gender) values (15, 'Olenka Galier', 'ogaliere@reddit.com', 'FEMALE');
insert into student (id, name, email, gender) values (16, 'Harlie Dimond', 'hdimondf@vistaprint.com', 'FEMALE');
insert into student (id, name, email, gender) values (17, 'Auberta Ferrara', 'aferrarag@google.es', 'FEMALE');
insert into student (id, name, email, gender) values (18, 'Kincaid Strut', 'kstruth@yahoo.co.jp', 'MALE');
insert into student (id, name, email, gender) values (19, 'Carma Louys', 'clouysi@berkeley.edu', 'FEMALE');
insert into student (id, name, email, gender) values (20, 'Georgina Espinel', 'gespinelj@sphinn.com', 'FEMALE');
insert into student (id, name, email, gender) values (21, 'Nanice Brute', 'nbrutek@fc2.com', 'FEMALE');
insert into student (id, name, email, gender) values (22, 'Tera Feak', 'tfeakl@quantcast.com', 'FEMALE');
insert into student (id, name, email, gender) values (23, 'Judie Wreak', 'jwreakm@cmu.edu', 'FEMALE');
insert into student (id, name, email, gender) values (24, 'Jeramie Lockery', 'jlockeryn@paginegialle.it', 'MALE');
insert into student (id, name, email, gender) values (25, 'Sandi Ogger', 'soggero@un.org', 'FEMALE');
insert into student (id, name, email, gender) values (26, 'Cyrus Hicken', 'chickenp@cnet.com', 'MALE');
insert into student (id, name, email, gender) values (27, 'Honor Rawstorn', 'hrawstornq@live.com', 'FEMALE');
insert into student (id, name, email, gender) values (28, 'Hetty Sames', 'hsamesr@auda.org.au', 'FEMALE');
insert into student (id, name, email, gender) values (29, 'Anderson Middas', 'amiddass@adobe.com', 'MALE');
insert into student (id, name, email, gender) values (30, 'Holli Burberye', 'hburberyet@skyrock.com', 'FEMALE');
insert into student (id, name, email, gender) values (31, 'Fleurette Heaffey', 'fheaffeyu@people.com.cn', 'FEMALE');
insert into student (id, name, email, gender) values (32, 'Johnathon Morsom', 'jmorsomv@goodreads.com', 'MALE');
insert into student (id, name, email, gender) values (33, 'Jayson Frowde', 'jfrowdew@whitehouse.gov', 'MALE');
insert into student (id, name, email, gender) values (34, 'Massimo Capini', 'mcapinix@nhs.uk', 'MALE');
insert into student (id, name, email, gender) values (35, 'Ephrayim Spafford', 'espaffordy@nih.gov', 'MALE');
insert into student (id, name, email, gender) values (36, 'Vere Gorce', 'vgorcez@cafepress.com', 'FEMALE');
insert into student (id, name, email, gender) values (37, 'Reid Endean', 'rendean10@seesaa.net', 'MALE');
insert into student (id, name, email, gender) values (38, 'Cinderella Trineman', 'ctrineman11@va.gov', 'FEMALE');
insert into student (id, name, email, gender) values (39, 'Amelie Billitteri', 'abillitteri12@usgs.gov', 'FEMALE');
insert into student (id, name, email, gender) values (40, 'Keenan Lumox', 'klumox13@ox.ac.uk', 'MALE');
insert into student (id, name, email, gender) values (41, 'Sansone Wride', 'swride14@photobucket.com', 'MALE');
insert into student (id, name, email, gender) values (42, 'Knox Boyne', 'kboyne15@flavors.me', 'MALE');
insert into student (id, name, email, gender) values (43, 'Mozes Hibling', 'mhibling16@prweb.com', 'MALE');
insert into student (id, name, email, gender) values (44, 'Rainer Holdren', 'rholdren17@usda.gov', 'MALE');
insert into student (id, name, email, gender) values (45, 'Nanci Labon', 'nlabon18@topsy.com', 'FEMALE');
insert into student (id, name, email, gender) values (46, 'Zarla Fucher', 'zfucher19@google.pl', 'FEMALE');
insert into student (id, name, email, gender) values (47, 'Mac Ollett', 'mollett1a@scribd.com', 'MALE');
insert into student (id, name, email, gender) values (48, 'Lindsay Cominoli', 'lcominoli1b@imdb.com', 'MALE');
insert into student (id, name, email, gender) values (49, 'Grethel Dodding', 'gdodding1c@upenn.edu', 'FEMALE');
insert into student (id, name, email, gender) values (50, 'Illa Dealy', 'idealy1d@163.com', 'FEMALE');
insert into student (id, name, email, gender) values (51, 'Benito Gibby', 'bgibby1e@amazon.co.uk', 'MALE');
insert into student (id, name, email, gender) values (52, 'Reinald Duckfield', 'rduckfield1f@tmall.com', 'MALE');
insert into student (id, name, email, gender) values (53, 'Athena Hucke', 'ahucke1g@jimdo.com', 'FEMALE');
insert into student (id, name, email, gender) values (54, 'Lanie Karczinski', 'lkarczinski1h@newsvine.com', 'FEMALE');
insert into student (id, name, email, gender) values (55, 'Michaeline Tripcony', 'mtripcony1i@bizjournals.com', 'FEMALE');
insert into student (id, name, email, gender) values (56, 'Vanya Blythe', 'vblythe1j@yolasite.com', 'MALE');
insert into student (id, name, email, gender) values (57, 'Haily Streatley', 'hstreatley1k@creativecommons.org', 'FEMALE');
insert into student (id, name, email, gender) values (58, 'Abelard Mariotte', 'amariotte1l@examiner.com', 'MALE');
insert into student (id, name, email, gender) values (59, 'Laina Rabjohn', 'lrabjohn1m@archive.org', 'FEMALE');
insert into student (id, name, email, gender) values (60, 'Mada Dunlop', 'mdunlop1n@vistaprint.com', 'FEMALE');
insert into student (id, name, email, gender) values (61, 'Bamby Dohmann', 'bdohmann1o@dion.ne.jp', 'FEMALE');
insert into student (id, name, email, gender) values (62, 'Garrick Philot', 'gphilot1p@ustream.tv', 'MALE');
insert into student (id, name, email, gender) values (63, 'Mile Galbreath', 'mgalbreath1q@t-online.de', 'MALE');
insert into student (id, name, email, gender) values (64, 'Prudence Thurlbeck', 'pthurlbeck1r@mlb.com', 'FEMALE');
insert into student (id, name, email, gender) values (65, 'Geordie De Bruijne', 'gde1s@studiopress.com', 'MALE');
insert into student (id, name, email, gender) values (66, 'Ida Everard', 'ieverard1t@ow.ly', 'FEMALE');
insert into student (id, name, email, gender) values (67, 'Petra Vaissiere', 'pvaissiere1u@mysql.com', 'FEMALE');
insert into student (id, name, email, gender) values (68, 'Zeke MacMorland', 'zmacmorland1v@army.mil', 'MALE');
insert into student (id, name, email, gender) values (69, 'Findley Potapczuk', 'fpotapczuk1w@woothemes.com', 'MALE');
insert into student (id, name, email, gender) values (70, 'Ansley Hulles', 'ahulles1x@stanford.edu', 'FEMALE');
insert into student (id, name, email, gender) values (71, 'Elly Wigley', 'ewigley1y@google.fr', 'FEMALE');
insert into student (id, name, email, gender) values (72, 'Urbano Renny', 'urenny1z@zdnet.com', 'MALE');
insert into student (id, name, email, gender) values (73, 'Luke Woolatt', 'lwoolatt20@chicagotribune.com', 'MALE');
insert into student (id, name, email, gender) values (74, 'Andi Trounce', 'atrounce21@cpanel.net', 'FEMALE');
insert into student (id, name, email, gender) values (75, 'Annadiane Kitchingman', 'akitchingman22@baidu.com', 'FEMALE');
insert into student (id, name, email, gender) values (76, 'Andee Dilston', 'adilston23@forbes.com', 'FEMALE');
insert into student (id, name, email, gender) values (77, 'Candide Persicke', 'cpersicke24@google.it', 'FEMALE');
insert into student (id, name, email, gender) values (78, 'Annabella Cockrem', 'acockrem25@flickr.com', 'FEMALE');
insert into student (id, name, email, gender) values (79, 'Francyne Coombe', 'fcoombe26@salon.com', 'FEMALE');
insert into student (id, name, email, gender) values (80, 'Charmine Shark', 'cshark27@fema.gov', 'FEMALE');
insert into student (id, name, email, gender) values (81, 'Sibby Bakster', 'sbakster28@msu.edu', 'FEMALE');
insert into student (id, name, email, gender) values (82, 'Hadlee Hughlin', 'hhughlin29@nbcnews.com', 'MALE');
insert into student (id, name, email, gender) values (83, 'Stevena Bernadon', 'sbernadon2a@about.me', 'FEMALE');
insert into student (id, name, email, gender) values (84, 'Jud Fairman', 'jfairman2b@wiley.com', 'MALE');
insert into student (id, name, email, gender) values (85, 'Fleming Audley', 'faudley2c@simplemachines.org', 'MALE');
insert into student (id, name, email, gender) values (86, 'Stillmann Blakiston', 'sblakiston2d@dyndns.org', 'MALE');
insert into student (id, name, email, gender) values (87, 'Tarrah Kiloh', 'tkiloh2e@storify.com', 'FEMALE');
insert into student (id, name, email, gender) values (88, 'Abran Apfelmann', 'aapfelmann2f@sciencedaily.com', 'MALE');
insert into student (id, name, email, gender) values (89, 'Allsun Rolfe', 'arolfe2g@purevolume.com', 'FEMALE');
insert into student (id, name, email, gender) values (90, 'Bethanne Donner', 'bdonner2h@marriott.com', 'FEMALE');
insert into student (id, name, email, gender) values (91, 'Sophi Kendal', 'skendal2i@squidoo.com', 'FEMALE');
insert into student (id, name, email, gender) values (92, 'Barb Plues', 'bplues2j@amazon.com', 'FEMALE');
insert into student (id, name, email, gender) values (93, 'Kass Spilisy', 'kspilisy2k@tinypic.com', 'FEMALE');
insert into student (id, name, email, gender) values (94, 'Beltran Spellsworth', 'bspellsworth2l@purevolume.com', 'MALE');
insert into student (id, name, email, gender) values (95, 'Bunny Jostan', 'bjostan2m@plala.or.jp', 'FEMALE');
insert into student (id, name, email, gender) values (96, 'Yehudit Udall', 'yudall2n@acquirethisname.com', 'MALE');
insert into student (id, name, email, gender) values (97, 'Hershel Curnnok', 'hcurnnok2o@lulu.com', 'MALE');
insert into student (id, name, email, gender) values (98, 'Idell Hayford', 'ihayford2p@nymag.com', 'FEMALE');
insert into student (id, name, email, gender) values (99, 'Lauree Danneil', 'ldanneil2q@netlog.com', 'FEMALE');
insert into student (id, name, email, gender) values (100, 'Baird Northey', 'bnorthey2r@etsy.com', 'MALE');
insert into student (id, name, email, gender) values (101, 'Mignon Peatt', 'mpeatt2s@blogtalkradio.com', 'FEMALE');
insert into student (id, name, email, gender) values (102, 'Carree Bridle', 'cbridle2t@blinklist.com', 'FEMALE');
insert into student (id, name, email, gender) values (103, 'Reggis Ferns', 'rferns2u@delicious.com', 'MALE');
insert into student (id, name, email, gender) values (104, 'Brunhilda McKennan', 'bmckennan2v@stumbleupon.com', 'FEMALE');
insert into student (id, name, email, gender) values (105, 'Catina Featherstonehaugh', 'cfeatherstonehaugh2w@google.ca', 'FEMALE');
insert into student (id, name, email, gender) values (106, 'Celestine Pydcock', 'cpydcock2x@boston.com', 'FEMALE');
insert into student (id, name, email, gender) values (107, 'Garner Hexter', 'ghexter2y@studiopress.com', 'MALE');
insert into student (id, name, email, gender) values (108, 'Salem Harteley', 'sharteley2z@tamu.edu', 'MALE');
insert into student (id, name, email, gender) values (109, 'Antin Gennrich', 'agennrich30@cnbc.com', 'MALE');
insert into student (id, name, email, gender) values (110, 'Pepe Eckery', 'peckery31@dyndns.org', 'MALE');
insert into student (id, name, email, gender) values (111, 'Jessie Carslaw', 'jcarslaw32@last.fm', 'MALE');
insert into student (id, name, email, gender) values (112, 'Murry Philipet', 'mphilipet33@domainmarket.com', 'MALE');
insert into student (id, name, email, gender) values (113, 'Sari Coltart', 'scoltart34@quantcast.com', 'FEMALE');
insert into student (id, name, email, gender) values (114, 'Calypso Kreber', 'ckreber35@irs.gov', 'FEMALE');
insert into student (id, name, email, gender) values (115, 'Paola Ridges', 'pridges36@google.com.hk', 'FEMALE');
insert into student (id, name, email, gender) values (116, 'Skye MacCook', 'smaccook37@mlb.com', 'MALE');
insert into student (id, name, email, gender) values (117, 'Wyatt Sommerlin', 'wsommerlin38@addthis.com', 'MALE');
insert into student (id, name, email, gender) values (118, 'Taber Djurisic', 'tdjurisic39@weather.com', 'MALE');
insert into student (id, name, email, gender) values (119, 'Lita Youngman', 'lyoungman3a@privacy.gov.au', 'FEMALE');
insert into student (id, name, email, gender) values (120, 'Ricky Wavish', 'rwavish3b@wix.com', 'MALE');
insert into student (id, name, email, gender) values (121, 'Laureen Bossel', 'lbossel3c@seattletimes.com', 'FEMALE');
insert into student (id, name, email, gender) values (122, 'Herbie Yves', 'hyves3d@rakuten.co.jp', 'MALE');
insert into student (id, name, email, gender) values (123, 'Conroy Jaquet', 'cjaquet3e@yelp.com', 'MALE');
insert into student (id, name, email, gender) values (124, 'Lusa Ruller', 'lruller3f@g.co', 'FEMALE');
insert into student (id, name, email, gender) values (125, 'Karola Wellings', 'kwellings3g@utexas.edu', 'FEMALE');
insert into student (id, name, email, gender) values (126, 'Dion Patley', 'dpatley3h@indiatimes.com', 'FEMALE');
insert into student (id, name, email, gender) values (127, 'Putnam Synke', 'psynke3i@sfgate.com', 'MALE');
insert into student (id, name, email, gender) values (128, 'Biron Enden', 'benden3j@webs.com', 'MALE');
insert into student (id, name, email, gender) values (129, 'Thorsten Landsberg', 'tlandsberg3k@etsy.com', 'MALE');
insert into student (id, name, email, gender) values (130, 'Berny Monroe', 'bmonroe3l@samsung.com', 'FEMALE');
insert into student (id, name, email, gender) values (131, 'Etheline Wrankmore', 'ewrankmore3m@npr.org', 'FEMALE');
insert into student (id, name, email, gender) values (132, 'Carroll Bolderson', 'cbolderson3n@si.edu', 'MALE');
insert into student (id, name, email, gender) values (133, 'Ginelle Shrigley', 'gshrigley3o@ox.ac.uk', 'FEMALE');
insert into student (id, name, email, gender) values (134, 'Adam Sinney', 'asinney3p@yahoo.co.jp', 'MALE');
insert into student (id, name, email, gender) values (135, 'Lorettalorna Orgill', 'lorgill3q@webmd.com', 'FEMALE');
insert into student (id, name, email, gender) values (136, 'Odetta Key', 'okey3r@dagondesign.com', 'FEMALE');
insert into student (id, name, email, gender) values (137, 'Conn Shalcros', 'cshalcros3s@so-net.ne.jp', 'MALE');
insert into student (id, name, email, gender) values (138, 'Wittie McLae', 'wmclae3t@list-manage.com', 'MALE');
insert into student (id, name, email, gender) values (139, 'Hedwig Pawson', 'hpawson3u@harvard.edu', 'FEMALE');
insert into student (id, name, email, gender) values (140, 'Peterus Stapylton', 'pstapylton3v@dagondesign.com', 'MALE');
insert into student (id, name, email, gender) values (141, 'Anni Gauch', 'agauch3w@sciencedaily.com', 'FEMALE');
insert into student (id, name, email, gender) values (142, 'Sidoney Cluet', 'scluet3x@apple.com', 'FEMALE');
insert into student (id, name, email, gender) values (143, 'Andee Maypother', 'amaypother3y@cargocollective.com', 'FEMALE');
insert into student (id, name, email, gender) values (144, 'Nancey Ballaam', 'nballaam3z@instagram.com', 'FEMALE');
insert into student (id, name, email, gender) values (145, 'Lisle Scholl', 'lscholl40@g.co', 'MALE');
insert into student (id, name, email, gender) values (146, 'Giacinta Muscott', 'gmuscott41@buzzfeed.com', 'FEMALE');
insert into student (id, name, email, gender) values (147, 'Rolph Snuggs', 'rsnuggs42@wisc.edu', 'MALE');
insert into student (id, name, email, gender) values (148, 'Burl Eddowes', 'beddowes43@prweb.com', 'MALE');
insert into student (id, name, email, gender) values (149, 'Logan Reyne', 'lreyne44@springer.com', 'MALE');
insert into student (id, name, email, gender) values (150, 'Hogan Dellow', 'hdellow45@google.co.jp', 'MALE');
insert into student (id, name, email, gender) values (151, 'Milt Betz', 'mbetz46@harvard.edu', 'MALE');
insert into student (id, name, email, gender) values (152, 'Katrine Beelby', 'kbeelby47@myspace.com', 'FEMALE');
insert into student (id, name, email, gender) values (153, 'Kippar Bigrigg', 'kbigrigg48@washingtonpost.com', 'MALE');
insert into student (id, name, email, gender) values (154, 'Kerianne Duferie', 'kduferie49@mlb.com', 'FEMALE');
insert into student (id, name, email, gender) values (155, 'Humberto Eadie', 'headie4a@howstuffworks.com', 'MALE');
insert into student (id, name, email, gender) values (156, 'Elise Harrigan', 'eharrigan4b@chronoengine.com', 'FEMALE');
insert into student (id, name, email, gender) values (157, 'Reuben Hadye', 'rhadye4c@ning.com', 'MALE');
insert into student (id, name, email, gender) values (158, 'Tony Stert', 'tstert4d@jimdo.com', 'MALE');
insert into student (id, name, email, gender) values (159, 'Hope Ellershaw', 'hellershaw4e@rediff.com', 'FEMALE');
insert into student (id, name, email, gender) values (160, 'Yevette Lamonby', 'ylamonby4f@paypal.com', 'FEMALE');
insert into student (id, name, email, gender) values (161, 'Mohandis Haly', 'mhaly4g@google.co.uk', 'MALE');
insert into student (id, name, email, gender) values (162, 'Royce Lodwick', 'rlodwick4h@google.it', 'MALE');
insert into student (id, name, email, gender) values (163, 'Kissiah Stammers', 'kstammers4i@mayoclinic.com', 'FEMALE');
insert into student (id, name, email, gender) values (164, 'Shellysheldon Grayshon', 'sgrayshon4j@oracle.com', 'MALE');
insert into student (id, name, email, gender) values (165, 'Audie Sorrell', 'asorrell4k@amazon.co.uk', 'FEMALE');
insert into student (id, name, email, gender) values (166, 'Robinet Dury', 'rdury4l@howstuffworks.com', 'FEMALE');
insert into student (id, name, email, gender) values (167, 'Haskell Butrimovich', 'hbutrimovich4m@princeton.edu', 'MALE');
insert into student (id, name, email, gender) values (168, 'Isabel Goomes', 'igoomes4n@discuz.net', 'FEMALE');
insert into student (id, name, email, gender) values (169, 'Leodora Butchers', 'lbutchers4o@marketwatch.com', 'FEMALE');
insert into student (id, name, email, gender) values (170, 'Mahala MacGrath', 'mmacgrath4p@home.pl', 'FEMALE');
insert into student (id, name, email, gender) values (171, 'Stephine Chatteris', 'schatteris4q@chron.com', 'FEMALE');
insert into student (id, name, email, gender) values (172, 'Galvan Aloway', 'galoway4r@upenn.edu', 'MALE');
insert into student (id, name, email, gender) values (173, 'Verney Duckitt', 'vduckitt4s@oaic.gov.au', 'MALE');
insert into student (id, name, email, gender) values (174, 'Theodora Allone', 'tallone4t@usgs.gov', 'FEMALE');
insert into student (id, name, email, gender) values (175, 'Bobbye O''Currigan', 'bocurrigan4u@foxnews.com', 'FEMALE');
insert into student (id, name, email, gender) values (176, 'Joelynn Clemendot', 'jclemendot4v@mozilla.org', 'FEMALE');
insert into student (id, name, email, gender) values (177, 'Ruthi Knipe', 'rknipe4w@sphinn.com', 'FEMALE');
insert into student (id, name, email, gender) values (178, 'Winfred Alvis', 'walvis4x@i2i.jp', 'MALE');
insert into student (id, name, email, gender) values (179, 'Ursa Ayers', 'uayers4y@youtube.com', 'FEMALE');
insert into student (id, name, email, gender) values (180, 'Eleanore Scallan', 'escallan4z@icio.us', 'FEMALE');
insert into student (id, name, email, gender) values (181, 'Mirabella Penrice', 'mpenrice50@ftc.gov', 'FEMALE');
insert into student (id, name, email, gender) values (182, 'Bill Arlett', 'barlett51@sfgate.com', 'MALE');
insert into student (id, name, email, gender) values (183, 'Geoff Shipley', 'gshipley52@nbcnews.com', 'MALE');
insert into student (id, name, email, gender) values (184, 'Thea Gigg', 'tgigg53@reddit.com', 'FEMALE');
insert into student (id, name, email, gender) values (185, 'Con De Carolis', 'cde54@youku.com', 'FEMALE');
insert into student (id, name, email, gender) values (186, 'Ariana Chicotti', 'achicotti55@blogger.com', 'FEMALE');
insert into student (id, name, email, gender) values (187, 'Shayna Uttley', 'suttley56@webs.com', 'FEMALE');
insert into student (id, name, email, gender) values (188, 'Marcelle Gilardi', 'mgilardi57@1688.com', 'FEMALE');
insert into student (id, name, email, gender) values (189, 'Yehudit Doram', 'ydoram58@infoseek.co.jp', 'MALE');
insert into student (id, name, email, gender) values (190, 'Kynthia Pichan', 'kpichan59@ucsd.edu', 'FEMALE');
insert into student (id, name, email, gender) values (191, 'Pablo Hosburn', 'phosburn5a@dedecms.com', 'MALE');
insert into student (id, name, email, gender) values (192, 'Nilson Lilywhite', 'nlilywhite5b@accuweather.com', 'MALE');
insert into student (id, name, email, gender) values (193, 'Link Smorthit', 'lsmorthit5c@bigcartel.com', 'MALE');
insert into student (id, name, email, gender) values (194, 'Stillmann Kerfoot', 'skerfoot5d@cargocollective.com', 'MALE');
insert into student (id, name, email, gender) values (195, 'Helena Baudino', 'hbaudino5e@live.com', 'FEMALE');
insert into student (id, name, email, gender) values (196, 'Merola Pargetter', 'mpargetter5f@umn.edu', 'FEMALE');
insert into student (id, name, email, gender) values (197, 'Rosalie Cortese', 'rcortese5g@webnode.com', 'FEMALE');
insert into student (id, name, email, gender) values (198, 'Reube Domenicone', 'rdomenicone5h@godaddy.com', 'MALE');
insert into student (id, name, email, gender) values (199, 'Carroll Coldham', 'ccoldham5i@jugem.jp', 'MALE');
insert into student (id, name, email, gender) values (200, 'Brooks Luxton', 'bluxton5j@deliciousdays.com', 'FEMALE');
insert into student (id, name, email, gender) values (201, 'Aime Dibnah', 'adibnah5k@nasa.gov', 'FEMALE');
insert into student (id, name, email, gender) values (202, 'Melli Gagan', 'mgagan5l@google.it', 'FEMALE');
insert into student (id, name, email, gender) values (203, 'Otho Cushion', 'ocushion5m@upenn.edu', 'MALE');
insert into student (id, name, email, gender) values (204, 'Lettie Falshaw', 'lfalshaw5n@uiuc.edu', 'FEMALE');
insert into student (id, name, email, gender) values (205, 'Kimbra Kohn', 'kkohn5o@facebook.com', 'FEMALE');
insert into student (id, name, email, gender) values (206, 'Maddie Drury', 'mdrury5p@prnewswire.com', 'MALE');
insert into student (id, name, email, gender) values (207, 'Wald Jado', 'wjado5q@patch.com', 'MALE');
insert into student (id, name, email, gender) values (208, 'Zacharia Madoc-Jones', 'zmadocjones5r@engadget.com', 'MALE');
insert into student (id, name, email, gender) values (209, 'Andres Ruoff', 'aruoff5s@arstechnica.com', 'MALE');
insert into student (id, name, email, gender) values (210, 'Trent Bellhouse', 'tbellhouse5t@cloudflare.com', 'MALE');
insert into student (id, name, email, gender) values (211, 'Dwayne Yurkov', 'dyurkov5u@smh.com.au', 'MALE');
insert into student (id, name, email, gender) values (212, 'Paige Chretien', 'pchretien5v@people.com.cn', 'MALE');
insert into student (id, name, email, gender) values (213, 'Heriberto Samart', 'hsamart5w@infoseek.co.jp', 'MALE');
insert into student (id, name, email, gender) values (214, 'Julie Balchin', 'jbalchin5x@pcworld.com', 'FEMALE');
insert into student (id, name, email, gender) values (215, 'Anthony Dashkov', 'adashkov5y@woothemes.com', 'MALE');
insert into student (id, name, email, gender) values (216, 'Lee Swoffer', 'lswoffer5z@nyu.edu', 'MALE');
insert into student (id, name, email, gender) values (217, 'Arny Leblanc', 'aleblanc60@hubpages.com', 'MALE');
insert into student (id, name, email, gender) values (218, 'Carolyn Schusterl', 'cschusterl61@stanford.edu', 'FEMALE');
insert into student (id, name, email, gender) values (219, 'Rogerio Meere', 'rmeere62@arstechnica.com', 'MALE');
insert into student (id, name, email, gender) values (220, 'Rutter Sieb', 'rsieb63@mayoclinic.com', 'MALE');
insert into student (id, name, email, gender) values (221, 'Franz Mervyn', 'fmervyn64@twitpic.com', 'MALE');
insert into student (id, name, email, gender) values (222, 'Philbert Clemo', 'pclemo65@soundcloud.com', 'MALE');
insert into student (id, name, email, gender) values (223, 'Otto De Biasio', 'ode66@4shared.com', 'MALE');
insert into student (id, name, email, gender) values (224, 'Cacilia Hathway', 'chathway67@gravatar.com', 'FEMALE');
insert into student (id, name, email, gender) values (225, 'Blake Coughan', 'bcoughan68@google.pl', 'FEMALE');
insert into student (id, name, email, gender) values (226, 'Rosanne Athowe', 'rathowe69@gravatar.com', 'FEMALE');
insert into student (id, name, email, gender) values (227, 'Ella Abbie', 'eabbie6a@ft.com', 'FEMALE');
insert into student (id, name, email, gender) values (228, 'Mariska Storrar', 'mstorrar6b@unblog.fr', 'FEMALE');
insert into student (id, name, email, gender) values (229, 'Damaris Sanderson', 'dsanderson6c@utexas.edu', 'FEMALE');
insert into student (id, name, email, gender) values (230, 'Case Clemenceau', 'cclemenceau6d@berkeley.edu', 'MALE');
insert into student (id, name, email, gender) values (231, 'Philippa Oake', 'poake6e@scribd.com', 'FEMALE');
insert into student (id, name, email, gender) values (232, 'Isis Haffenden', 'ihaffenden6f@yelp.com', 'FEMALE');
insert into student (id, name, email, gender) values (233, 'Orville Sizey', 'osizey6g@fema.gov', 'MALE');
insert into student (id, name, email, gender) values (234, 'Adam Asplen', 'aasplen6h@domainmarket.com', 'MALE');
insert into student (id, name, email, gender) values (235, 'Danny Lanaway', 'dlanaway6i@cnn.com', 'MALE');
insert into student (id, name, email, gender) values (236, 'Corinna Crowdace', 'ccrowdace6j@auda.org.au', 'FEMALE');
insert into student (id, name, email, gender) values (237, 'Ermina Ascough', 'eascough6k@pbs.org', 'FEMALE');
insert into student (id, name, email, gender) values (238, 'Werner Gammage', 'wgammage6l@state.tx.us', 'MALE');
insert into student (id, name, email, gender) values (239, 'Logan Kalisch', 'lkalisch6m@freewebs.com', 'MALE');
insert into student (id, name, email, gender) values (240, 'Lorianna Mincher', 'lmincher6n@slideshare.net', 'FEMALE');
insert into student (id, name, email, gender) values (241, 'Goldi Faughey', 'gfaughey6o@shop-pro.jp', 'FEMALE');
insert into student (id, name, email, gender) values (242, 'Moira Storck', 'mstorck6p@yahoo.co.jp', 'FEMALE');
insert into student (id, name, email, gender) values (243, 'Avie Walby', 'awalby6q@fda.gov', 'FEMALE');
insert into student (id, name, email, gender) values (244, 'Enrico Simondson', 'esimondson6r@cdc.gov', 'MALE');
insert into student (id, name, email, gender) values (245, 'Rori Ebdin', 'rebdin6s@constantcontact.com', 'FEMALE');
insert into student (id, name, email, gender) values (246, 'Irv Marklund', 'imarklund6t@photobucket.com', 'MALE');
insert into student (id, name, email, gender) values (247, 'Dorisa Wellington', 'dwellington6u@smh.com.au', 'FEMALE');
insert into student (id, name, email, gender) values (248, 'Chan Gadeaux', 'cgadeaux6v@spiegel.de', 'MALE');
insert into student (id, name, email, gender) values (249, 'Lilla Lodwig', 'llodwig6w@constantcontact.com', 'FEMALE');
insert into student (id, name, email, gender) values (250, 'Sylvan Mercy', 'smercy6x@delicious.com', 'MALE');
insert into student (id, name, email, gender) values (251, 'Burton Barbisch', 'bbarbisch6y@opera.com', 'MALE');
insert into student (id, name, email, gender) values (252, 'Miguela MacCracken', 'mmaccracken6z@feedburner.com', 'FEMALE');
insert into student (id, name, email, gender) values (253, 'Rena Niven', 'rniven70@nsw.gov.au', 'FEMALE');
insert into student (id, name, email, gender) values (254, 'Dinnie Wemyss', 'dwemyss71@apple.com', 'FEMALE');
insert into student (id, name, email, gender) values (255, 'Ber Lello', 'blello72@theatlantic.com', 'MALE');
insert into student (id, name, email, gender) values (256, 'Donny Pinson', 'dpinson73@theglobeandmail.com', 'MALE');
insert into student (id, name, email, gender) values (257, 'Jania Pallant', 'jpallant74@pbs.org', 'FEMALE');
insert into student (id, name, email, gender) values (258, 'Reiko Pentelow', 'rpentelow75@canalblog.com', 'FEMALE');
insert into student (id, name, email, gender) values (259, 'Peirce Stoyell', 'pstoyell76@mapy.cz', 'MALE');
insert into student (id, name, email, gender) values (260, 'Fancie Ygo', 'fygo77@cbc.ca', 'FEMALE');
insert into student (id, name, email, gender) values (261, 'Arin Scowcroft', 'ascowcroft78@cpanel.net', 'MALE');
insert into student (id, name, email, gender) values (262, 'Emmery Trenchard', 'etrenchard79@msn.com', 'MALE');
insert into student (id, name, email, gender) values (263, 'Hephzibah Fodden', 'hfodden7a@studiopress.com', 'FEMALE');
insert into student (id, name, email, gender) values (264, 'Nanni Skaid', 'nskaid7b@ihg.com', 'FEMALE');
insert into student (id, name, email, gender) values (265, 'Roanna Whittock', 'rwhittock7c@cmu.edu', 'FEMALE');
insert into student (id, name, email, gender) values (266, 'Ivan Heasly', 'iheasly7d@hugedomains.com', 'MALE');
insert into student (id, name, email, gender) values (267, 'Julieta Johnston', 'jjohnston7e@technorati.com', 'FEMALE');
insert into student (id, name, email, gender) values (268, 'Ulberto Dahlberg', 'udahlberg7f@comsenz.com', 'MALE');
insert into student (id, name, email, gender) values (269, 'Cassondra Shoosmith', 'cshoosmith7g@sbwire.com', 'FEMALE');
insert into student (id, name, email, gender) values (270, 'Sibley Wellard', 'swellard7h@hud.gov', 'FEMALE');
insert into student (id, name, email, gender) values (271, 'Temple Matokhnin', 'tmatokhnin7i@walmart.com', 'MALE');
insert into student (id, name, email, gender) values (272, 'Xymenes Dallender', 'xdallender7j@examiner.com', 'MALE');
insert into student (id, name, email, gender) values (273, 'Dulce Besnardeau', 'dbesnardeau7k@wsj.com', 'FEMALE');
insert into student (id, name, email, gender) values (274, 'Robinson Magarrell', 'rmagarrell7l@example.com', 'MALE');
insert into student (id, name, email, gender) values (275, 'Glynis Strevens', 'gstrevens7m@boston.com', 'FEMALE');
insert into student (id, name, email, gender) values (276, 'Alard Snartt', 'asnartt7n@wordpress.org', 'MALE');
insert into student (id, name, email, gender) values (277, 'Linnet Alekseicik', 'lalekseicik7o@parallels.com', 'FEMALE');
insert into student (id, name, email, gender) values (278, 'Romeo Armfirld', 'rarmfirld7p@wp.com', 'MALE');
insert into student (id, name, email, gender) values (279, 'Creight Adolthine', 'cadolthine7q@twitter.com', 'MALE');
insert into student (id, name, email, gender) values (280, 'Colet Fardo', 'cfardo7r@mediafire.com', 'MALE');
insert into student (id, name, email, gender) values (281, 'Daile Taveriner', 'dtaveriner7s@mtv.com', 'FEMALE');
insert into student (id, name, email, gender) values (282, 'Vinni Roz', 'vroz7t@bandcamp.com', 'FEMALE');
insert into student (id, name, email, gender) values (283, 'Baillie Weddeburn', 'bweddeburn7u@discovery.com', 'MALE');
insert into student (id, name, email, gender) values (284, 'Michal Ferrarini', 'mferrarini7v@merriam-webster.com', 'MALE');
insert into student (id, name, email, gender) values (285, 'Bettye Pacey', 'bpacey7w@omniture.com', 'FEMALE');
insert into student (id, name, email, gender) values (286, 'Berkley Dovidian', 'bdovidian7x@friendfeed.com', 'MALE');
insert into student (id, name, email, gender) values (287, 'Freda Landsman', 'flandsman7y@oaic.gov.au', 'FEMALE');
insert into student (id, name, email, gender) values (288, 'Dolores Mattimoe', 'dmattimoe7z@spotify.com', 'FEMALE');
insert into student (id, name, email, gender) values (289, 'Everard Catlette', 'ecatlette80@time.com', 'MALE');
insert into student (id, name, email, gender) values (290, 'Beau Cargenven', 'bcargenven81@shop-pro.jp', 'MALE');
insert into student (id, name, email, gender) values (291, 'Josiah Osmond', 'josmond82@xinhuanet.com', 'MALE');
insert into student (id, name, email, gender) values (292, 'Krisha Draco', 'kdraco83@geocities.com', 'MALE');
insert into student (id, name, email, gender) values (293, 'Nickolas Boutwell', 'nboutwell84@chronoengine.com', 'MALE');
insert into student (id, name, email, gender) values (294, 'Talbert Fantonetti', 'tfantonetti85@clickbank.net', 'MALE');
insert into student (id, name, email, gender) values (295, 'Corbin Erni', 'cerni86@bbc.co.uk', 'MALE');
insert into student (id, name, email, gender) values (296, 'Torrence Ratcliff', 'tratcliff87@wix.com', 'MALE');
insert into student (id, name, email, gender) values (297, 'Shaylyn Muncer', 'smuncer88@spotify.com', 'FEMALE');
insert into student (id, name, email, gender) values (298, 'Allyn Bilbie', 'abilbie89@gmpg.org', 'MALE');
insert into student (id, name, email, gender) values (299, 'Lynette Mc Caughan', 'lmc8a@google.de', 'FEMALE');
insert into student (id, name, email, gender) values (300, 'Alessandro Spours', 'aspours8b@apache.org', 'MALE');
insert into student (id, name, email, gender) values (301, 'Norean Noar', 'nnoar8c@ftc.gov', 'FEMALE');
insert into student (id, name, email, gender) values (302, 'Clare Ruggier', 'cruggier8d@lulu.com', 'MALE');
insert into student (id, name, email, gender) values (303, 'Brantley Ram', 'bram8e@clickbank.net', 'MALE');
insert into student (id, name, email, gender) values (304, 'Brenda Sandbach', 'bsandbach8f@netlog.com', 'FEMALE');
insert into student (id, name, email, gender) values (305, 'Bron Ingyon', 'bingyon8g@cloudflare.com', 'MALE');
insert into student (id, name, email, gender) values (306, 'Guy Crockford', 'gcrockford8h@ca.gov', 'MALE');
insert into student (id, name, email, gender) values (307, 'Florance Northgraves', 'fnorthgraves8i@cdbaby.com', 'FEMALE');
insert into student (id, name, email, gender) values (308, 'Ariel Swyne', 'aswyne8j@reddit.com', 'FEMALE');
insert into student (id, name, email, gender) values (309, 'Marylinda Raecroft', 'mraecroft8k@dropbox.com', 'FEMALE');
insert into student (id, name, email, gender) values (310, 'Britney Mankor', 'bmankor8l@nyu.edu', 'FEMALE');
insert into student (id, name, email, gender) values (311, 'Tasha Weyman', 'tweyman8m@marketwatch.com', 'FEMALE');
insert into student (id, name, email, gender) values (312, 'Farlie Sebley', 'fsebley8n@altervista.org', 'MALE');
insert into student (id, name, email, gender) values (313, 'Lou Bog', 'lbog8o@trellian.com', 'MALE');
insert into student (id, name, email, gender) values (314, 'Kimble Scotchmur', 'kscotchmur8p@ted.com', 'MALE');
insert into student (id, name, email, gender) values (315, 'Rollins Ferreira', 'rferreira8q@goodreads.com', 'MALE');
insert into student (id, name, email, gender) values (316, 'Ettore Smorthit', 'esmorthit8r@dmoz.org', 'MALE');
insert into student (id, name, email, gender) values (317, 'Ugo Prinnett', 'uprinnett8s@sakura.ne.jp', 'MALE');
insert into student (id, name, email, gender) values (318, 'Tabbie Somers', 'tsomers8t@earthlink.net', 'MALE');
insert into student (id, name, email, gender) values (319, 'Donavon Piggin', 'dpiggin8u@typepad.com', 'MALE');
insert into student (id, name, email, gender) values (320, 'Basilius Voden', 'bvoden8v@mapquest.com', 'MALE');
insert into student (id, name, email, gender) values (321, 'Skippy Tirkin', 'stirkin8w@wunderground.com', 'MALE');
insert into student (id, name, email, gender) values (322, 'Pyotr Ockenden', 'pockenden8x@nyu.edu', 'MALE');
insert into student (id, name, email, gender) values (323, 'Launce Arderne', 'larderne8y@flavors.me', 'MALE');
insert into student (id, name, email, gender) values (324, 'Garwin Klulicek', 'gklulicek8z@ezinearticles.com', 'MALE');
insert into student (id, name, email, gender) values (325, 'Nahum Antoniutti', 'nantoniutti90@ask.com', 'MALE');
insert into student (id, name, email, gender) values (326, 'Hal Nan Carrow', 'hnan91@exblog.jp', 'MALE');
insert into student (id, name, email, gender) values (327, 'Torin Davenhill', 'tdavenhill92@about.me', 'MALE');
insert into student (id, name, email, gender) values (328, 'Tamara Laffling', 'tlaffling93@angelfire.com', 'FEMALE');
insert into student (id, name, email, gender) values (329, 'Irene Innwood', 'iinnwood94@exblog.jp', 'FEMALE');
insert into student (id, name, email, gender) values (330, 'Martguerita Lonnon', 'mlonnon95@wisc.edu', 'FEMALE');
insert into student (id, name, email, gender) values (331, 'Olivie Penhaleurack', 'openhaleurack96@feedburner.com', 'FEMALE');
insert into student (id, name, email, gender) values (332, 'Danielle Grimditch', 'dgrimditch97@dion.ne.jp', 'FEMALE');
insert into student (id, name, email, gender) values (333, 'Waldemar Deackes', 'wdeackes98@wp.com', 'MALE');
insert into student (id, name, email, gender) values (334, 'Jordanna Benford', 'jbenford99@simplemachines.org', 'FEMALE');
insert into student (id, name, email, gender) values (335, 'Aldo Hazlegrove', 'ahazlegrove9a@weebly.com', 'MALE');
insert into student (id, name, email, gender) values (336, 'Irvin Perryman', 'iperryman9b@shareasale.com', 'MALE');
insert into student (id, name, email, gender) values (337, 'Gage Tipton', 'gtipton9c@rakuten.co.jp', 'MALE');
insert into student (id, name, email, gender) values (338, 'Sile Pollack', 'spollack9d@furl.net', 'FEMALE');
insert into student (id, name, email, gender) values (339, 'Florian Bertrand', 'fbertrand9e@friendfeed.com', 'MALE');
insert into student (id, name, email, gender) values (340, 'Reinaldos Fitchew', 'rfitchew9f@stanford.edu', 'MALE');
insert into student (id, name, email, gender) values (341, 'Bambie Tchir', 'btchir9g@goo.gl', 'FEMALE');
insert into student (id, name, email, gender) values (342, 'Urban Scarlin', 'uscarlin9h@unicef.org', 'MALE');
insert into student (id, name, email, gender) values (343, 'Kamillah Batcock', 'kbatcock9i@theglobeandmail.com', 'FEMALE');
insert into student (id, name, email, gender) values (344, 'Rosie Clemo', 'rclemo9j@friendfeed.com', 'FEMALE');
insert into student (id, name, email, gender) values (345, 'Adelbert Georges', 'ageorges9k@ucoz.com', 'MALE');
insert into student (id, name, email, gender) values (346, 'Purcell Pessler', 'ppessler9l@examiner.com', 'MALE');
insert into student (id, name, email, gender) values (347, 'Josh Malshinger', 'jmalshinger9m@mlb.com', 'MALE');
insert into student (id, name, email, gender) values (348, 'Delano Laffan', 'dlaffan9n@artisteer.com', 'MALE');
insert into student (id, name, email, gender) values (349, 'Danell Foxten', 'dfoxten9o@liveinternet.ru', 'FEMALE');
insert into student (id, name, email, gender) values (350, 'Quent Andrews', 'qandrews9p@google.co.jp', 'MALE');
insert into student (id, name, email, gender) values (351, 'Igor Sangwine', 'isangwine9q@nhs.uk', 'MALE');
insert into student (id, name, email, gender) values (352, 'Bartolomeo Schuchmacher', 'bschuchmacher9r@deviantart.com', 'MALE');
insert into student (id, name, email, gender) values (353, 'Halette Beszant', 'hbeszant9s@dailymotion.com', 'FEMALE');
insert into student (id, name, email, gender) values (354, 'Douglass Barbary', 'dbarbary9t@spiegel.de', 'MALE');
insert into student (id, name, email, gender) values (355, 'Clareta Flindall', 'cflindall9u@usda.gov', 'FEMALE');
insert into student (id, name, email, gender) values (356, 'Maurise Roberto', 'mroberto9v@nytimes.com', 'MALE');
insert into student (id, name, email, gender) values (357, 'Dannie Postin', 'dpostin9w@gmpg.org', 'MALE');
insert into student (id, name, email, gender) values (358, 'Tanya Eshmade', 'teshmade9x@nbcnews.com', 'FEMALE');
insert into student (id, name, email, gender) values (359, 'Christen Gother', 'cgother9y@aboutads.info', 'FEMALE');
insert into student (id, name, email, gender) values (360, 'Arin Sabattier', 'asabattier9z@ihg.com', 'MALE');
insert into student (id, name, email, gender) values (361, 'Gothart Stebbin', 'gstebbina0@angelfire.com', 'MALE');
insert into student (id, name, email, gender) values (362, 'Daisey Ottam', 'dottama1@g.co', 'FEMALE');
insert into student (id, name, email, gender) values (363, 'Lucine Bulley', 'lbulleya2@examiner.com', 'FEMALE');
insert into student (id, name, email, gender) values (364, 'Madelon Tupman', 'mtupmana3@discovery.com', 'FEMALE');
insert into student (id, name, email, gender) values (365, 'Yuma Rankling', 'yranklinga4@paginegialle.it', 'MALE');
insert into student (id, name, email, gender) values (366, 'Blinni Grubb', 'bgrubba5@berkeley.edu', 'FEMALE');
insert into student (id, name, email, gender) values (367, 'Garner Hoolaghan', 'ghoolaghana6@wikimedia.org', 'MALE');
insert into student (id, name, email, gender) values (368, 'Wilton Mabbutt', 'wmabbutta7@google.pl', 'MALE');
insert into student (id, name, email, gender) values (369, 'Meredithe Kinnerley', 'mkinnerleya8@netlog.com', 'FEMALE');
insert into student (id, name, email, gender) values (370, 'Maximilien Otridge', 'motridgea9@google.it', 'MALE');
insert into student (id, name, email, gender) values (371, 'Freeland Frankom', 'ffrankomaa@who.int', 'MALE');
insert into student (id, name, email, gender) values (372, 'Creight Nozzolii', 'cnozzoliiab@mysql.com', 'MALE');
insert into student (id, name, email, gender) values (373, 'Lyndsie Drains', 'ldrainsac@webeden.co.uk', 'FEMALE');
insert into student (id, name, email, gender) values (374, 'Olia Abramowitz', 'oabramowitzad@nhs.uk', 'FEMALE');
insert into student (id, name, email, gender) values (375, 'Carlene Beavis', 'cbeavisae@wsj.com', 'FEMALE');
insert into student (id, name, email, gender) values (376, 'Enrico Fitter', 'efitteraf@gravatar.com', 'MALE');
insert into student (id, name, email, gender) values (377, 'Ferdinanda Matzeitis', 'fmatzeitisag@elegantthemes.com', 'FEMALE');
insert into student (id, name, email, gender) values (378, 'Tori Farleigh', 'tfarleighah@goodreads.com', 'FEMALE');
insert into student (id, name, email, gender) values (379, 'Hagan Kinavan', 'hkinavanai@statcounter.com', 'MALE');
insert into student (id, name, email, gender) values (380, 'Wenonah Ende', 'wendeaj@gnu.org', 'FEMALE');
insert into student (id, name, email, gender) values (381, 'Valentino McPaike', 'vmcpaikeak@economist.com', 'MALE');
insert into student (id, name, email, gender) values (382, 'Sydney Schulze', 'sschulzeal@rakuten.co.jp', 'MALE');
insert into student (id, name, email, gender) values (383, 'Zacharias Futcher', 'zfutcheram@posterous.com', 'MALE');
insert into student (id, name, email, gender) values (384, 'Ugo Feltham', 'ufelthaman@mediafire.com', 'MALE');
insert into student (id, name, email, gender) values (385, 'Austina McKeever', 'amckeeverao@joomla.org', 'FEMALE');
insert into student (id, name, email, gender) values (386, 'Ethan Bedrosian', 'ebedrosianap@flavors.me', 'MALE');
insert into student (id, name, email, gender) values (387, 'Evan Cuddy', 'ecuddyaq@loc.gov', 'MALE');
insert into student (id, name, email, gender) values (388, 'Felix Gemnett', 'fgemnettar@photobucket.com', 'MALE');
insert into student (id, name, email, gender) values (389, 'Archibaldo Konzel', 'akonzelas@weather.com', 'MALE');
insert into student (id, name, email, gender) values (390, 'Johann Hargess', 'jhargessat@xinhuanet.com', 'MALE');
insert into student (id, name, email, gender) values (391, 'Sigmund Callister', 'scallisterau@wikia.com', 'MALE');
insert into student (id, name, email, gender) values (392, 'Rivalee Prettejohns', 'rprettejohnsav@webeden.co.uk', 'FEMALE');
insert into student (id, name, email, gender) values (393, 'Cary Crackett', 'ccrackettaw@yale.edu', 'FEMALE');
insert into student (id, name, email, gender) values (394, 'Sebastien Coode', 'scoodeax@t.co', 'MALE');
insert into student (id, name, email, gender) values (395, 'Kori Volante', 'kvolanteay@who.int', 'FEMALE');
insert into student (id, name, email, gender) values (396, 'Martyn Magarrell', 'mmagarrellaz@mail.ru', 'MALE');
insert into student (id, name, email, gender) values (397, 'Brose Witul', 'bwitulb0@ow.ly', 'MALE');
insert into student (id, name, email, gender) values (398, 'Lissy Marczyk', 'lmarczykb1@cnet.com', 'FEMALE');
insert into student (id, name, email, gender) values (399, 'Donn Brecknell', 'dbrecknellb2@loc.gov', 'MALE');
insert into student (id, name, email, gender) values (400, 'Drona Armytage', 'darmytageb3@hexun.com', 'FEMALE');
insert into student (id, name, email, gender) values (401, 'Clyde Skala', 'cskalab4@scribd.com', 'MALE');
insert into student (id, name, email, gender) values (402, 'Josefina Phizaclea', 'jphizacleab5@deliciousdays.com', 'FEMALE');
insert into student (id, name, email, gender) values (403, 'Franchot Wyldes', 'fwyldesb6@opensource.org', 'MALE');
insert into student (id, name, email, gender) values (404, 'Urbanus Penhalewick', 'upenhalewickb7@altervista.org', 'MALE');
insert into student (id, name, email, gender) values (405, 'Nerti Brunon', 'nbrunonb8@washingtonpost.com', 'FEMALE');
insert into student (id, name, email, gender) values (406, 'Julianna Dorsey', 'jdorseyb9@weebly.com', 'FEMALE');
insert into student (id, name, email, gender) values (407, 'Pernell Dungey', 'pdungeyba@skype.com', 'MALE');
insert into student (id, name, email, gender) values (408, 'Yehudit Rockliffe', 'yrockliffebb@aboutads.info', 'MALE');
insert into student (id, name, email, gender) values (409, 'Benjamin Dunston', 'bdunstonbc@wufoo.com', 'MALE');
insert into student (id, name, email, gender) values (410, 'Giff Dacombe', 'gdacombebd@etsy.com', 'MALE');
insert into student (id, name, email, gender) values (411, 'Roseann Ivanin', 'rivaninbe@un.org', 'FEMALE');
insert into student (id, name, email, gender) values (412, 'Ernesta Dallman', 'edallmanbf@theatlantic.com', 'FEMALE');
insert into student (id, name, email, gender) values (413, 'Selinda Cundey', 'scundeybg@berkeley.edu', 'FEMALE');
insert into student (id, name, email, gender) values (414, 'Alfie Swadling', 'aswadlingbh@independent.co.uk', 'MALE');
insert into student (id, name, email, gender) values (415, 'Clarance Skehens', 'cskehensbi@cnet.com', 'MALE');
insert into student (id, name, email, gender) values (416, 'Austin Eeles', 'aeelesbj@nasa.gov', 'MALE');
insert into student (id, name, email, gender) values (417, 'Cale Pepys', 'cpepysbk@tripod.com', 'MALE');
insert into student (id, name, email, gender) values (418, 'Jaimie Menzies', 'jmenziesbl@ted.com', 'MALE');
insert into student (id, name, email, gender) values (419, 'Nerita Bane', 'nbanebm@purevolume.com', 'FEMALE');
insert into student (id, name, email, gender) values (420, 'Erroll Pendred', 'ependredbn@nasa.gov', 'MALE');
insert into student (id, name, email, gender) values (421, 'Jock Larraway', 'jlarrawaybo@rakuten.co.jp', 'MALE');
insert into student (id, name, email, gender) values (422, 'Skipton Slowly', 'sslowlybp@photobucket.com', 'MALE');
insert into student (id, name, email, gender) values (423, 'Michail Bandt', 'mbandtbq@sourceforge.net', 'MALE');
insert into student (id, name, email, gender) values (424, 'Clemmy Cleyburn', 'ccleyburnbr@opera.com', 'MALE');
insert into student (id, name, email, gender) values (425, 'Nikolaus Musson', 'nmussonbs@360.cn', 'MALE');
insert into student (id, name, email, gender) values (426, 'Carmel Caddies', 'ccaddiesbt@sina.com.cn', 'FEMALE');
insert into student (id, name, email, gender) values (427, 'Violante Gravestone', 'vgravestonebu@whitehouse.gov', 'FEMALE');
insert into student (id, name, email, gender) values (428, 'Davin Wigsell', 'dwigsellbv@moonfruit.com', 'MALE');
insert into student (id, name, email, gender) values (429, 'Rod Trenoweth', 'rtrenowethbw@umn.edu', 'MALE');
insert into student (id, name, email, gender) values (430, 'Carl Byrch', 'cbyrchbx@godaddy.com', 'MALE');
insert into student (id, name, email, gender) values (431, 'Lorena Sleany', 'lsleanyby@diigo.com', 'FEMALE');
insert into student (id, name, email, gender) values (432, 'Paige Radband', 'pradbandbz@pen.io', 'MALE');
insert into student (id, name, email, gender) values (433, 'Kath Pittford', 'kpittfordc0@ucla.edu', 'FEMALE');
insert into student (id, name, email, gender) values (434, 'Jerrilee Iacabucci', 'jiacabuccic1@nhs.uk', 'FEMALE');
insert into student (id, name, email, gender) values (435, 'Kessiah Bridden', 'kbriddenc2@businessinsider.com', 'FEMALE');
insert into student (id, name, email, gender) values (436, 'Jane Furniss', 'jfurnissc3@icio.us', 'FEMALE');
insert into student (id, name, email, gender) values (437, 'Suzy Govinlock', 'sgovinlockc4@qq.com', 'FEMALE');
insert into student (id, name, email, gender) values (438, 'Artemis Gullan', 'agullanc5@paginegialle.it', 'MALE');
insert into student (id, name, email, gender) values (439, 'Ilka Palley', 'ipalleyc6@businessweek.com', 'FEMALE');
insert into student (id, name, email, gender) values (440, 'Abner Swanbourne', 'aswanbournec7@people.com.cn', 'MALE');
insert into student (id, name, email, gender) values (441, 'Antonino Bouchier', 'abouchierc8@cafepress.com', 'MALE');
insert into student (id, name, email, gender) values (442, 'Mitchel Rivaland', 'mrivalandc9@google.nl', 'MALE');
insert into student (id, name, email, gender) values (443, 'Abigale Heaffey', 'aheaffeyca@ovh.net', 'FEMALE');
insert into student (id, name, email, gender) values (444, 'Carmella Brimmacombe', 'cbrimmacombecb@nytimes.com', 'FEMALE');
insert into student (id, name, email, gender) values (445, 'Michel Jeffs', 'mjeffscc@taobao.com', 'MALE');
insert into student (id, name, email, gender) values (446, 'Isahella Langwade', 'ilangwadecd@tiny.cc', 'FEMALE');
insert into student (id, name, email, gender) values (447, 'Niall Bratt', 'nbrattce@tripadvisor.com', 'MALE');
insert into student (id, name, email, gender) values (448, 'Silvain Belin', 'sbelincf@chron.com', 'MALE');
insert into student (id, name, email, gender) values (449, 'Matthus Grimley', 'mgrimleycg@hp.com', 'MALE');
insert into student (id, name, email, gender) values (450, 'Bradney Emby', 'bembych@newsvine.com', 'MALE');
insert into student (id, name, email, gender) values (451, 'Eamon Stapley', 'estapleyci@pbs.org', 'MALE');
insert into student (id, name, email, gender) values (452, 'Gino Dudderidge', 'gdudderidgecj@xrea.com', 'MALE');
insert into student (id, name, email, gender) values (453, 'Esteban Ruske', 'eruskeck@123-reg.co.uk', 'MALE');
insert into student (id, name, email, gender) values (454, 'Charlot Coppock.', 'ccoppockcl@berkeley.edu', 'FEMALE');
insert into student (id, name, email, gender) values (455, 'Melina Dobbinson', 'mdobbinsoncm@mapquest.com', 'FEMALE');
insert into student (id, name, email, gender) values (456, 'Dorine Bogart', 'dbogartcn@prweb.com', 'FEMALE');
insert into student (id, name, email, gender) values (457, 'Ferguson Quinney', 'fquinneyco@wordpress.org', 'MALE');
insert into student (id, name, email, gender) values (458, 'Hildagard Padefield', 'hpadefieldcp@phpbb.com', 'FEMALE');
insert into student (id, name, email, gender) values (459, 'Marijn Esparza', 'mesparzacq@cornell.edu', 'MALE');
insert into student (id, name, email, gender) values (460, 'Anna-diana Mengue', 'amenguecr@acquirethisname.com', 'FEMALE');
insert into student (id, name, email, gender) values (461, 'Desmond Venard', 'dvenardcs@arizona.edu', 'MALE');
insert into student (id, name, email, gender) values (462, 'Chilton Grafton', 'cgraftonct@blogspot.com', 'MALE');
insert into student (id, name, email, gender) values (463, 'Gwenni Craik', 'gcraikcu@cnn.com', 'FEMALE');
insert into student (id, name, email, gender) values (464, 'Angie Hrinchishin', 'ahrinchishincv@addthis.com', 'MALE');
insert into student (id, name, email, gender) values (465, 'Cordey Scolts', 'cscoltscw@example.com', 'FEMALE');
insert into student (id, name, email, gender) values (466, 'Rochell Finding', 'rfindingcx@opera.com', 'FEMALE');
insert into student (id, name, email, gender) values (467, 'Livia Wickens', 'lwickenscy@chronoengine.com', 'FEMALE');
insert into student (id, name, email, gender) values (468, 'Antonius Jantot', 'ajantotcz@mac.com', 'MALE');
insert into student (id, name, email, gender) values (469, 'Matty Poleye', 'mpoleyed0@mail.ru', 'FEMALE');
insert into student (id, name, email, gender) values (470, 'Walker Lennox', 'wlennoxd1@gravatar.com', 'MALE');
insert into student (id, name, email, gender) values (471, 'Bartolemo Zettoi', 'bzettoid2@pagesperso-orange.fr', 'MALE');
insert into student (id, name, email, gender) values (472, 'Mervin Gopsell', 'mgopselld3@exblog.jp', 'MALE');
insert into student (id, name, email, gender) values (473, 'Jodi Murby', 'jmurbyd4@paginegialle.it', 'MALE');
insert into student (id, name, email, gender) values (474, 'Nertie MacRirie', 'nmacriried5@usnews.com', 'FEMALE');
insert into student (id, name, email, gender) values (475, 'Berkley Pichmann', 'bpichmannd6@cloudflare.com', 'MALE');
insert into student (id, name, email, gender) values (476, 'Reginauld Bates', 'rbatesd7@cnet.com', 'MALE');
insert into student (id, name, email, gender) values (477, 'Trstram Alvin', 'talvind8@purevolume.com', 'MALE');
insert into student (id, name, email, gender) values (478, 'Martha Calverd', 'mcalverdd9@g.co', 'FEMALE');
insert into student (id, name, email, gender) values (479, 'Emilia Castelot', 'ecastelotda@unc.edu', 'FEMALE');
insert into student (id, name, email, gender) values (480, 'Tiphani Edgerly', 'tedgerlydb@dropbox.com', 'FEMALE');
insert into student (id, name, email, gender) values (481, 'Brittne Gabbitis', 'bgabbitisdc@devhub.com', 'FEMALE');
insert into student (id, name, email, gender) values (482, 'Sheppard Mence', 'smencedd@msu.edu', 'MALE');
insert into student (id, name, email, gender) values (483, 'Meier Antonietti', 'mantoniettide@wp.com', 'MALE');
insert into student (id, name, email, gender) values (484, 'Romy Dowden', 'rdowdendf@meetup.com', 'FEMALE');
insert into student (id, name, email, gender) values (485, 'Waldemar Cron', 'wcrondg@people.com.cn', 'MALE');
insert into student (id, name, email, gender) values (486, 'Paco Squeers', 'psqueersdh@usnews.com', 'MALE');
insert into student (id, name, email, gender) values (487, 'Abdel Clemetts', 'aclemettsdi@umn.edu', 'MALE');
insert into student (id, name, email, gender) values (488, 'Jourdain Kernermann', 'jkernermanndj@edublogs.org', 'MALE');
insert into student (id, name, email, gender) values (489, 'Findlay Curbishley', 'fcurbishleydk@cargocollective.com', 'MALE');
insert into student (id, name, email, gender) values (490, 'Bab Belchem', 'bbelchemdl@smugmug.com', 'FEMALE');
insert into student (id, name, email, gender) values (491, 'Aron Brownstein', '

最低0.47元/天解锁文章