Jump to content


Photo

Whole Contacts Table


  • Please log in to reply
1 reply to this topic

#1 serpicot

serpicot

    New Member

  • Members
  • Pip
  • 1 posts

Posted 19 October 2009 - 10:40 PM

Hi, lads!

Here you go the whole table, I hope is useful.
(Sorry if the post already exists)
Create:

CREATE TABLE contacts
( last_name varchar(30) NOT NULL,
first_name varchar(20) NOT NULL,
email varchar(50) NOT NULL,
gender char(1) NOT NULL,
birthday VARCHAR(10) NOT NULL,
profession varchar(50) NOT NULL,
location varchar(50) NOT NULL,
state char(2) NOT NULL,
status varchar(20) NOT NULL,
interests varchar(100) NOT NULL,
seeking varchar(100) NOT NULL);


Insert:

INSERT INTO contacts VALUES ('Anderson','Jillian','jill_anderson@ breakneckpizza.com','F','29469','Technical Writer','Palo Alto',' CA','single','kayaking reptiles relationship',' friends');
INSERT INTO contacts VALUES ('Kenton','Leo','lkenton@starbuzzcoffee.com','M','27039','Manager','San Francisco',' CA','divorced','women','women to date');;
INSERT INTO contacts VALUES ('McGavin','Darrin',' captainlove@headfirsttheater.com','M','24130','Cruise Ship Captain','San Diego',' CA','single','sailing fishing yachting','women for casual relationships');;
INSERT INTO contacts VALUES ('Franklin','Joe','joe_franklin@leapinlimos.com','M','28243','Software Sales','Dallas',' TX','married',' fishing drinking','new job');;
INSERT INTO contacts VALUES ('Hamilton','Jamie','dontbother@starbuzzcoffee.com','F','23630','System Administrator','Princeton',' NJ','married','RPG','nothing');;
INSERT INTO contacts VALUES ('Chevrolet','Maurice','bookman4u@objectville.net','M','22828','Bookshop Owner','Mountain View',' CA','married','collecting books,scuba diving','friends');
INSERT INTO contacts VALUES ('Kroger','Renee','poorrenee@mightygumball.net','F','28097','Unemployed','San Francisco',' CA','divorced','cooking','employment');
INSERT INTO contacts VALUES ('Mendoza','Angelina','angelina@starbuzzcoffee.com','F','29086','UNIX Sysadmin','San Francisco',' CA','married acting dancing','new job','');
INSERT INTO contacts VALUES ('Murphy','Donald','padraic@tikibeanlounge.com','M','24495','Computer Programmer','New York City',' NY','committed relationsh','RPG, anime','friends');
INSERT INTO contacts VALUES ('Spatner','John','jpoet@objectville.net','M','23119','Salesman','Woodstock',' NY','married','poetry, screenwriting','');
INSERT INTO contacts VALUES ('Toth','Anne','Anne_Toth@leapinlimos.com','F','25525','Artist','San Fran',' CA','taken','sql, databases','employees');
INSERT INTO contacts VALUES ('Manson','Anne','am86@objectville.net','F','28346','Baker','Seattle',' WA','single','cooking,dancing','a boyfriend');
INSERT INTO contacts VALUES ('Hardy','Anne','anneh@b0tt0msup.com','F','23119','Teacher','San Fran',' CA','taken','information technology recruitment','coworkers');
INSERT INTO contacts VALUES ('Parker','Anne','annep@starbuzzcoffee.com','F','30326','Student','San Fran',' CA','single','horror movies beatboxing','men');
INSERT INTO contacts VALUES ('Blunt','Anne','anneblunt@breakneckpizza.com','F','21832','Web Designer','San Fran',' CA','single','smoking partying design patterns','a party companion');
INSERT INTO contacts VALUES ('Jacobs','Anne','anne99@objectville.net','F','24873','Computer Programmer','San Jose',' CA','in an open relations homebrewing curling','women','');
INSERT INTO contacts VALUES ('Reese','David','dresse@simuduck.com','M','29385','Web Designer','Sunnyvale',' CA','single','outdoor activities reading playing music travel cooking ','friends');
INSERT INTO contacts VALUES ('Soukup','Alan','soukup@breakneckpizza.net','M','24289','Aeronautical Engineer','San Antonio',' TX','married','RPG programming','nothing');
INSERT INTO contacts VALUES ('Bailey','Sarah','sarabailey@simuduck.com','F','27743','Advertising Engineer','San Antonio',' TX','single','movies exercise cruises','men');
INSERT INTO contacts VALUES ('Fiore','Carla','cfiore@fioreanimalclinic.com','F','27036','Veterinarian','Round Rock',' TX','single','horseback riding movies animals','single men');
INSERT INTO contacts VALUES ('Prophet','Francine','prophet@breakneckpizza.net','F','27730','Campaign Manager','Cambridge',' MA','single','dogs knitting embroidery','friends');
INSERT INTO contacts VALUES ('Ferguson','Alexis','alexangel@yahoo.com','F','20717','Artist','Pflugerville','MA','single','animals, dolls, hunting taxidermy','single men');
INSERT INTO contacts VALUES ('Coleman','Chris','coleman@objectvillediner.com','M','25252','Vintner','Napa',' CA','single','wine, travel','men to date');
INSERT INTO contacts VALUES ('Moire','Roger','roger007@honey-doit.com','M','28370','Snake Trainer','San Mateo',' CA','divorced','reptiles camping kayaking','relationship');
INSERT INTO contacts VALUES ('McKinnon','Gilligan','gilligan@boards-r-us.com','M','22587','Accountant','Key West',' FL','single','pirates pilates travel','women to date');
INSERT INTO contacts VALUES ('Welby','Marca','doctormarca@yahoo.com','F','29374','Doctor','Boston',' MA','single','scrubs, house, greys anatomies','single women');
INSERT INTO contacts VALUES ('Chapman','Alexandra','alex@headfirstlabs.com','F','27977','Technical Writer','Princeton',' NJ','committed relationsh','reading creative writing poetry','freelance work');
INSERT INTO contacts VALUES ('Gardner','Shannon','sgardner@breakneckpizza.net','M','30082','Poet','New London',' CT','single','creative writing poetry amateur theatre','men');
INSERT INTO contacts VALUES ('Green','Robert','rob1212@objectville.net','M','24358','Unemployed','Corpus Christie',' TX','single','none','women and a job');
INSERT INTO contacts VALUES ('Davinci','Andrea','chef4you@objectville.net','F','27332','Professional Chef','Princeton',' NJ','single','cooking art opera','men to date');

ta.

#2 itechs

itechs

    New Member

  • Members
  • Pip
  • 3 posts

Posted 04 October 2011 - 04:15 AM

Hey,
Great Job Man. I appreciate for your efforts... Please keep up...


Thanks
Ash




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users