mysql-query.sql

CREATE TABLE `user_tbl` (
	`id` INT NOT NULL AUTO_INCREMENT,
	`first_name` VARCHAR(50) NULL DEFAULT NULL,
	`last_name` VARCHAR(50) NULL DEFAULT NULL,
	`email` VARCHAR(50) NULL DEFAULT NULL,
	`gender` VARCHAR(50) NULL DEFAULT NULL,
	`status` INT(11) NULL DEFAULT '1',
	PRIMARY KEY (`id`)
)
ENGINE=InnoDB
;



insert into user_tbl (first_name, last_name, email, gender) values ('Sauncho', 'Sugge', 'ssugge0@4shared.com', 'Male');
insert into user_tbl (first_name, last_name, email, gender) values ('Morna', 'Joannet', 'mjoannet1@example.com', 'Female');
insert into user_tbl (first_name, last_name, email, gender) values ('Faina', 'Abeau', 'fabeau2@amazon.co.uk', 'Female');
insert into user_tbl (first_name, last_name, email, gender) values ('Elvis', 'Potter', 'epotter3@opensource.org', 'Male');
insert into user_tbl (first_name, last_name, email, gender) values ('Simonette', 'Perell', 'sperell4@vinaora.com', 'Female');
insert into user_tbl (first_name, last_name, email, gender) values ('George', 'Dunkerton', 'gdunkerton5@hexun.com', 'Female');
insert into user_tbl (first_name, last_name, email, gender) values ('Chrissy', 'Baldazzi', 'cbaldazzi6@seattletimes.com', 'Male');
insert into user_tbl (first_name, last_name, email, gender) values ('Grazia', 'Cribbins', 'gcribbins7@macromedia.com', 'Female');
insert into user_tbl (first_name, last_name, email, gender) values ('Gilberte', 'D''Cruze', 'gdcruze8@eepurl.com', 'Female');
insert into user_tbl (first_name, last_name, email, gender) values ('Teddie', 'Yuranovev', 'tyuranovev9@geocities.com', 'Male');
insert into user_tbl (first_name, last_name, email, gender) values ('Olimpia', 'Povah', 'opovaha@ed.gov', 'Female');
insert into user_tbl (first_name, last_name, email, gender) values ('Rosmunda', 'Bagworth', 'rbagworthb@surveymonkey.com', 'Female');
insert into user_tbl (first_name, last_name, email, gender) values ('Adrien', 'Iacomelli', 'aiacomellic@g.co', 'Male');
insert into user_tbl (first_name, last_name, email, gender) values ('Sawyere', 'Andriesse', 'sandriessed@buzzfeed.com', 'Male');
insert into user_tbl (first_name, last_name, email, gender) values ('Martie', 'Gasnell', 'mgasnelle@miitbeian.gov.cn', 'Female');
insert into user_tbl (first_name, last_name, email, gender) values ('Reinhard', 'Stollenbeck', 'rstollenbeckf@multiply.com', 'Male');
insert into user_tbl (first_name, last_name, email, gender) values ('Sisile', 'Ciccotti', 'sciccottig@gravatar.com', 'Female');
insert into user_tbl (first_name, last_name, email, gender) values ('Denys', 'Catlow', 'dcatlowh@dailymotion.com', 'Male');
insert into user_tbl (first_name, last_name, email, gender) values ('Wyatan', 'Ferriby', 'wferribyi@marriott.com', 'Male');
insert into user_tbl (first_name, last_name, email, gender) values ('Angil', 'Dyka', 'adykaj@taobao.com', 'Female');
insert into user_tbl (first_name, last_name, email, gender) values ('Culley', 'Radclyffe', 'cradclyffek@google.com.au', 'Male');
insert into user_tbl (first_name, last_name, email, gender) values ('Darby', 'McCrossan', 'dmccrossanl@wikipedia.org', 'Female');
insert into user_tbl (first_name, last_name, email, gender) values ('Korney', 'Gewer', 'kgewerm@oakley.com', 'Female');
insert into user_tbl (first_name, last_name, email, gender) values ('Angus', 'Grahlman', 'agrahlmann@blogger.com', 'Male');
insert into user_tbl (first_name, last_name, email, gender) values ('Harmon', 'Levens', 'hlevenso@cisco.com', 'Male');
insert into user_tbl (first_name, last_name, email, gender) values ('Myer', 'Acreman', 'macremanp@hc360.com', 'Male');
insert into user_tbl (first_name, last_name, email, gender) values ('Terry', 'Gamett', 'tgamettq@nifty.com', 'Female');
insert into user_tbl (first_name, last_name, email, gender) values ('Kaia', 'Mirfield', 'kmirfieldr@mashable.com', 'Female');
insert into user_tbl (first_name, last_name, email, gender) values ('Freemon', 'Maureen', 'fmaureens@slate.com', 'Male');
insert into user_tbl (first_name, last_name, email, gender) values ('Bryna', 'Whittick', 'bwhittickt@blinklist.com', 'Female');
insert into user_tbl (first_name, last_name, email, gender) values ('Marve', 'Castangia', 'mcastangiau@upenn.edu', 'Male');
insert into user_tbl (first_name, last_name, email, gender) values ('Hillery', 'Moles', 'hmolesv@businesswire.com', 'Male');
insert into user_tbl (first_name, last_name, email, gender) values ('Edith', 'Satford', 'esatfordw@tinypic.com', 'Female');
insert into user_tbl (first_name, last_name, email, gender) values ('Shantee', 'Symons', 'ssymonsx@mayoclinic.com', 'Female');
insert into user_tbl (first_name, last_name, email, gender) values ('Anthiathia', 'Gwynne', 'agwynney@ft.com', 'Female');
insert into user_tbl (first_name, last_name, email, gender) values ('Mandie', 'Dowding', 'mdowdingz@wikispaces.com', 'Female');
insert into user_tbl (first_name, last_name, email, gender) values ('Alane', 'Bartkowiak', 'abartkowiak10@stanford.edu', 'Female');
insert into user_tbl (first_name, last_name, email, gender) values ('Amity', 'Callan', 'acallan11@google.fr', 'Female');
insert into user_tbl (first_name, last_name, email, gender) values ('Calv', 'Trewman', 'ctrewman12@cisco.com', 'Male');
insert into user_tbl (first_name, last_name, email, gender) values ('Iolande', 'Dyerson', 'idyerson13@cnn.com', 'Female')