Read Text file and insert only unique ones into mysql table

Multi tool use
Multi tool use

The name of the pictureThe name of the pictureThe name of the pictureClash Royale CLAN TAG#URR8PPP











up vote
0
down vote

favorite












I would like to insert URL's in banned_url_lists.txt text file into mysql database table called 'banned_url_links' There is also different characters in URL's e.g.(" ' " and " ") all urls should be inserting to mysql as it is.
I would like this script to check duplicate URL's in mysql column name 'links' and insert only unique ones (banned_url_links.txt text file is removed and and creating new links everyday, therefore duplicate checks has to be against mysql table not on text file). I want also inserting date for each records (I already done on mysql side but I am not sure it will work without sending date to mysql). My database structure, banned_url_lists.txt and bash script are below.



MYSQL table structure



Table (banned_url_links) structure

1 ID int(10) No None AUTO_INCREMENT
2 date timestamp No CURRENT_TIMESTAMP
3 links varchar(300) utf8_general_ci No None


My bash script



#!/bin/bash

host="1.1.1.1";
DBName='wpmy_db';
DBUser='wp_myuser';
DBPass='137T321uS&*3j5';
File=banned_url_list.txt;
MYSQL="mysql -u$ DBUser -p$ $DBName DBPass -h $host";
echo $MYSQL;

$MYSQL -e "INSERT INTO banned_url_links SET links = $File";
$MYSQL LOAD DATA INFILE 'banned_url_list.txt' INTO TABLE wpmy_db.links;
EOF


banned_url_links.txt



http://www.tricare.mil/ocfo/_docs/2011_R-5-1000%20_%20CPT%20Coding%20for%20Cardiac_Redacted.doc
http://www.berachahbiblechurch.org/assets4---exodus.doc
http://teacherweb.com/GA/Keheleyelementary/Johnson/MultipleMeaning.doc
http://teacherweb.com/VA/PaulVIHighSchool/MrsWhiting/8-2Heron.doc
http://www.fresnocitycollege.edu/Modules/ShowDocument.aspx?documentid=2277
http://www.mae.ncsu.edu/academics/truss-app/2014MathWorksPresentation.docx
http://teacherweb.com/VA/PaulVIHighSchool/MrsWhiting/Lesson-4-6-Rational-Equations-and-Partial-Fractions.docx
http://www.coffschurch.org.au/images/EPHESIANS%20FOR%20TODAY'S%20CHURCH.ppsx
http://www.asphn.org/resource_files/339/339_resource_file1.doc
http://www.rucharacter.org/file/Lesson1v2FINAL(1).pps
http://web.cs.sunyit.edu/~sengupta/cs330/MOS3e_ch7_97.docx
http://origin.library.constantcontact.com/download/get/file/1101686237960-61/Dont+Forget+about+Prolotherapy+LAOM+0913.docx
http://www.it-servizi.it/template/template_vari/Powerpoint_Templates/America%20the%20Beautiful.pot
https://royalmechanical.files.wordpress.com/2011/06/failure-of-rolling-contact-bearings.doc
http://capital.osd.wednet.edu/media/capital/staff/jansen/02_chemistry/Gen_Chemi_2016_The_Periodic_Table_final_one_docx.docx
http://washington.osd.wednet.edu/media/washington/staff/burroughs_candyce/energy/forms_nrg.doc
http://www.ccaeagles.org/file/GoToCollegeWithoutGoingBrokePowerPoint.doc
http://natres.psu.ac.th/Animal/disease_USA/Chicken%20dis/Leucosis%20MD.doc
https://research.wustl.edu/ComplianceAreas/ExportControls/Documents/ExportControls_RAForum_July2014.docx
http://champion-container.com/inside.php?zithromax-single-dose-gonorrhea.docx
http://gauntletpress.com/mix.php?how-much-allegra-to-get-high.docx
https://www.uscg.mil/hq/cg5/TVNCOE/Documents/Presentations/UTVCourse/SeattlePortland.docx
http://scisweb.ulster.ac.uk/~kevin/com535/slides/7%20Public%20Key%20Cryptography%20%26%20Message%20Authentication.docx
http://www.bsj.org.jm/Portals/0/ncbj/C_White%20Quality%20Management_A%20Financial%20Perspective%5B1%5D.doc
http://web43.canyons.edu/Faculty/naddafpoura/Bus110/Bus110-PrincOfMgmt-Ch01-PPP.doc
http://www.rhpc.us/go/doc/4207/1226799/3M-FR-57-Gas-Filter-Cartridge-docx
http://hr.southtexascollege.edu/forms/misc/2013-2014%20PERFORMANCE%20APPRAISAL.doc
http://ntp.neuroscience.wisc.edu/resource/cid/files/UW-Mad%20Ideas.doc
http://teacherweb.com/VA/PaulVIHighSchool/MrsWhiting/Lesson-4-5-Fundamental-Theorem-of-Algebra.docx
http://www.cse.wustl.edu/~vgruev/cse/260/lecture_slides/chapter9.docx
http://www.academic.luzerne.edu/jpisano/Copy%20of%2006%20Thinking
http://api.ning.com/files/a6fJNn6lELJMxMrXBKLma1d0EfZbYFfy-39lKasULAVvoAqP22qpFALQBU0ipoPtWZFPoPB2Imw9Gfo2U6TNrHdQETKhkgBm/CISCOFINAL.docx
http://fdin.org.uk/output/Packaging%2012/Cold%20Press%20Case%20Study.pps
http://www.midamerica.imanet.org/Web_Files/Sales_Tax_Streamlining.docx
http://www.ireeindia.org/iree/Firth-Whitwam.doc
http://www.mgdservices.com/QA.doc
http://www.msipc.org/wp-content/uploads/2013/02/Evaluation-of-UV-Light-Technology-and-CDI_Alison-Gibson-12.docx
http://wood-ridgeschools.org/cms/lib6/NJ01001835/Centricity/Domain/471/AchieveNJ%20SGO%202%200%20-%20from%20Compliance%20to%20Quality.docx
http://capital.osd.wednet.edu/media/capital/staff/machut/newtons_laws_of_motion-Machut.doc
https://assets.microsoft.com/en-us/apex_sellerguidance_1.docx
http://www.franklin.kyschools.us/Downloads/Body%20Composition%20Day%2015%202014.docx
http://www.pmr.vcu.edu/presentations/pps/PedMusculoskeletal.pps
http://www.renal.org/docs/default-source/clinical-service/clinical-service/CAB_Report_-_Dr_Kevin_Harris.doc?sfvrsn=0
https://assets.microsoft.com/en-us/Lync-Server-2010---Pricing-and-Licensing-Guide-for-Partners_1.docx
http://capital.osd.wednet.edu/media/capital/staff/samson/WizardofOz.doc
http://capital.osd.wednet.edu/media/capital/staff/jansen/chap._10_notes._v__a.doc
http://puurveltman.nl/best-antibiotic-for-sinus-infection-bactrim.docx
https://assets.microsoft.com/en-us/Enterprise-Cloud-Suite-customer-deck-for-partners_1.docx
http://home.apu.edu/~ksetterlund/2011-2012/FY%20Field%20Orientation%202011.doc
http://www.dataminingbook.com/system/files/Chap5_MultipleLinearRegression_0.doc
http://teacherweb.com/MA/LexingtonPublicSchools/highschoolbehs/aphgcore-areas2.doc
http://courses.softlab.ntua.gr/softeng/Tutorials/TutorialUML.doc
http://www3.canyons.edu/Faculty/rosalesr/202/Lectures/Chapter7.doc
http://capital.osd.wednet.edu/media/capital/staff/mcfadden/espresso_operations/co/vbr/vbr.l15.financial_statements.docx
http://rkala.in/download/From%20source%20to%20software.doc
http://www.shsu.edu/~agr_www/documents/U10L4.doc
http://www.up.edu/showimage/show.aspx?file=22142
http://www.sabresocials.com/jacquie/Geography%2012/Grade%2012%20Presenations/OZONE_DEPLETION2.doc
http://www.michigan.gov/documents/mde/Afterschool_Snack_Program_Training_Module_508679_7.docx
http://apps3.eere.energy.gov/greenpower/conference/4gpmc99/tutt.doc
http://www.lstechllc.com/beta/wp-content/uploads/2012/05/LST-Corporate-Briefing_2016-04-131.docx
http://education.ky.gov/teachers/pges/spges/documents/spges%20for%20training%20doc.docx
http://www.ucilmsa.org/The%20mexican%20health%20care%20system%20(Rios).doc
http://gauntletpress.com/volume.php?synthroid-generic-vs-brand-name.docx
http://puurveltman.nl/flagyl-200-mg-suspension.docx
https://www.nbb.be/doc/ts/products/paymentsystems/sepa/sepa_dd_mob_20100322.doc
http://www.franklin.kyschools.us/Downloads/Substitution%20Real%20World%20Problems.docx
http://garthmoon.com/static/imagesOpus/140613-1-vietnam-reference-file/Vietnam-Victoria-Healthcare/110613-Competitive-Analysis.docx
http://home.apu.edu/~ddavis/docpres/organizational_notes.doc
http://www.sabresocials.com/kevin/Programming11to12.doc
http://scisweb.ulster.ac.uk/~kevin/com320/slides/Chapter9-OperatingSystems.docx
http://www.markpatent.org/19thapril07/presentation/michel.DOC
http://teacherweb.com/GA/StarrsMillHighSchool/RobinHuggins/burns-powerpoint-2.doc
http://www.ccgcd.org/Education/Water%20Conservation%20DOC%20Draft%202.docx
http://www.jeffcoeoc.org/documents/MyStateUSA.docx
http://www.msipc.org/wp-content/uploads/2013/02/FIC-Slides-OccupationalHealth_2015.docx
http://www.lancastershrm.org/handouts/HRTechnology2.ppsx
http://capital.osd.wednet.edu/media/capital/staff/jansen/ib_chemistry/class_powerpoints/Topic_4.1_IB_Chem_Ionic_Bonding.doc
https://www.ut.edu.sa/documents/10156/2890319/lecture+2
http://grtc.ucsd.edu/old_essentials/2004/lecture5.pps
http://capital.osd.wednet.edu/media/capital/staff/jansen/ib_chemistry/class_powerpoints/Topic_1.1._States_of_Matter_docx.docx
http://www.dese.iisc.ernet.in/people/kgopa/CEDT_part1.doc
http://capital.osd.wednet.edu/media/capital/staff/finley/the_metric_system.doc
http://www.cmu.edu/finance/budget/overview/files/budget_theory_presentation.doc
http://mmbgims.com/docs/doc/3.ppsx
http://www.bath.kyschools.us/userfiles/64/Classes/4661/Guitar%20Unit%201-0.docx
http://cdn.metroparent.com/wp-content/uploads/Acting-Out-–-Simple-Ways-to-Improve-Your-Childs-Problem-Behavior.docx
https://www.quia.com/files/quia/users/jaratermann/__GV2016/Week8-perfect_tenses_rvsd3.docx
http://www.uta.edu/faculty/david/SAIR_2008.pps
http://www.cres-sn.org/conference/documents/Artificial_insemination_productivity_and_growth.docx
http://userpages.umbc.edu/~jc4/orals.doc
http://www.uvm.edu/rsenr/wfb279/presentations/Phytoplankton_Dynamics.doc
http://advising.uncc.edu/sites/advising.uncc.edu/files/media/Importance-of-Developmental-Advising-Especially-with-First-Generation-Students.docx
http://gravytrainpoutinerie.com/accident.php?otc-antibiotics.docx
http://www.midwestenergy.org/uploads/2/6/8/3/26833428/natgasbootcamp2014.docx
http://www.franklin.kyschools.us/Downloads/Informational%20Writing%20DOC.docx
http://capital.osd.wednet.edu/media/capital/staff/jansen/ib_chemistry/class_powerpoints/Topic_1.1._States_of_Matter_2017_docx.docx
http://www.breakingthemould.co.uk/files/Selby/TURKEY.pps
http://comsci.liu.edu/~jrodriguez/cs645sp10/chapter5.doc
http://www.the-hpo.com/downloads/Effective%20Business%20%20Process%20Mapping%20V10.doc
http://www.thekingsschoolwr.co.za/Tabdata/Grade%209/THINGS%20FALL%20APART%20new.docx
http://www.acjrca.org/doc08/11-%20HardenPandemic.doc
http://www.heartofthemidlandscfc.org/files/TheBigPicture6October2015.docx
http://www.studenthealthassociation.co.uk/conferences/2014/SHA_Travel_Presentation.doc
http://www.studiolegalesilvestrini.it/Presentazione_Avv_Silvestrini_3.doc
http://teacherweb.com/LA/RiversideElementarySchool-Shreveport/MrsSimmons/mayaaztecandinca1.doc
http://www.msipc.org/wp-content/uploads/2013/02/FIC-Slides-NrsgHomePneumonia_2015-.doc
http://web-01.canyons.edu/Faculty/naddafpoura/Bus100/Bus100Ch04PPP.doc
http://www.sabresocials.com/jacquie/Geography%2012/Grade%2012%20Presenations/Hydro-Wind%20Power2%20curtis%20leblanc.doc
http://nadp.sws.uiuc.edu/cladws/doc/galloway.doc
http://ucblibraries.colorado.edu/govpubs/conference/handouts/emetrics.doc
http://capital.osd.wednet.edu/media/capital/staff/jansen/chap.27notes.chordata_web.doc
http://www.goes-r.gov/downloads/GOES-R_Series_Program/2014/10-Anderson_pres.docx
http://www.avon.nhs.uk/phnet/Avonsafe/Falls-ResCare/Medicines%20and%20Falls.doc
http://www.soc.iastate.edu/Sapp/Feminist.doc
http://statler.wvu.edu/freshman/fya/StaA.docx
http://www.warrencountyschools.org/userfiles/2719/Classes/7849/01%20Endocrine%20and%20Cell%20Communication%20%20Introduction.docx
http://www.healthnettpo.org/files/716/qualitative-research-on-the-psychosocial-impact-of-war-on-children-in-burundi-and-indonesia-it-never-rains-it-pours.doc
http://teacherweb.com/LA/NorthshoreHighSchool/Guidance/TOPS--FAFSA-ETC-2015-Grads-AUG-2014-30-min.docx
https://assets.microsoft.com/en-us/Office-365-Ignite-BPOS-to-Office-365-Transition_1.docx
http://www2.sunysuffolk.edu/anastaj/OC%2015%20web%20page/Lectures/Powerpoint/Nekton%20F06.doc
http://faculty.mercer.edu/salido_t/BME426/Cardiac%20MRI.doc
http://www.ee.sc.edu/classes/Fall11/elct774/Class_Notes/ELCT_774_Lecture_19.doc
http://www.ce.washington.edu/~palmer/classes/CEE576/Lectures/Intro/Intro.doc
http://nsttac.org/sites/default/files/assets/doc/DoingtheRightThinginClintonArkansas.doc
http://download.microsoft.com/download/4/d/1/4d100840-8114-4716-9a05-f8632f56e6c1/UNC452-Schnoll.docx
http://www.omega6d.org/~omega6d/sites/default/files/Sixth_District_Undergraduate_Leadership_Summit_rev_7.ppsx
http://teacherweb.com/MA/LexingtonPublicSchools/highschoolbehs/AP-Green-Revolution1.doc
http://www.armasouthwest.org/crm_conferences/2016crm/materials/Adv.%20Track%206_Challenges%20of%20Information%20Governance.docx
http://www.nebraskamed.com/app_files/doc/sota/implementingrelationshipbasedcare.docx
http://grid.cs.gsu.edu/~cscbecx/Class%20Slides/CSCI%203360%20Database%20Systems/Chapter%202.doc
http://lms.abuad.edu.ng/claroline/backends/download.php?url=L0dTVF8xMTNfcHA1LnBwdHg%3D&cidReset=true&cidReq=GST113_002
http://mrjoycemtsinai.weebly.com/uploads/1/8/1/7/18175567/light_and_waves.docx
http://webapp.browardschools.com/esstorage/3221-35/presentation/CRDGoGreen.pps
http://capital.osd.wednet.edu/media/capital/staff/jansen/chap._6_notes._periodic_table.doc
http://teacherweb.com/LA/FontainebleauHighSchool/ChristyCMayfield/The-Final-Solution-7th-hour2.docx
https://assets.microsoft.com/en-us/Microsoft-Licensing-Options-for-Partner-Hosted-Cloud_1.docx
http://www.paychex.com/a/d/score/top-10-hr-traps-for-small-businesses.docx
http://www.msipc.org/wp-content/uploads/2013/02/C.-diff.-Clean-Differently-2013.docx
http://apps3.eere.energy.gov/greenpower/events/docs/0412_sappi.docx
http://www.msipc.org/wp-content/uploads/2013/02/FIC-Slides-Air_water_waste_2015_VanEnk-21.docx
https://assets.microsoft.com/en-uk/FY15-Lync-Hardware-Partner-Marketing-Playbook_1.docx
http://optimist.org/Documents/Optimist_in_Action_Day.doc
https://www.hud.gov/offices/pih/ih/news/expanding_circle/Documents/Track%202/Integrating%20Culture%20and%20Tradition/Cultural%20O%20Syd%20Beane.doc
http://seadoo-maldives.com/tension.php?lipitor-onset-peak-duration.docx
http://health.usf.edu/NR/rdonlyres/1DC16038-2A42-4ECE-A5E1-7E596579E679/0/QIGME.docx
http://www.womenshealth.gov/heart-truth/heart-truth-docs/Supplemental%20Slide%20Library/HormoneTherapy%20(Supplemental)%20100311.docx
http://teacherweb.com/GA/StarrsMillHighSchool/RobinHuggins/skin-conditions.doc
http://science.kennesaw.edu/%7Emdias/webpage/advanced%20organizers/Tectonics.doc
http://www.onrc.washington.edu/clearinghouse/presentations/acsmtza/acsmtza.DOC
http://ksumsc.com/download_center/4th/Anesthesia/Group%20B/Airway%20evaluation%20and%20management%20%282%29.ppsx
http://www.namica.org/webdocs/conf2014/Villanueva_NAMI%202014presentation.docx
https://assets.microsoft.com/en-us/Managing_Rebates_and_Co-Op_in_CHIP_1.docx
http://home.apu.edu/~ddavis/busi240/chap003_revised.doc
http://api.ning.com/files/lZvpxCE44sVBDaBfn3FvXGV8G97uX2hCzUj3HkPa89m8Mzmj4O8JDzphobEneQSryFQ64C8Tm7U0EBAyfDoD6xwg8csqCE4W/CUEVADEHANGSONDOONG.pps
https://perryhallhs.bcps.org/UserFiles/Servers/Server_4202033/File/Senior%20Assembly%20Graduation%20Info%20DOC.docx
http://www.soc.iastate.edu/sapp/Conflict.doc
http://capital.osd.wednet.edu/media/capital/staff/jansen/ib_chemistry/class_powerpoints/IB_Chemistry._Topic_4._Allotropes_of_Carbon_and_Intermolecular_Forces.docx
http://api.ning.com/files/StXfNzc3V8kX-jhPS4m3I8wsjQrIYsvMpMbvvIw*aEk0X5zBd2sn1CgQEAfZdUOrXe9oPxLbPV115q2JnI-wBnOBqNoih9ZV/Psalms1final2.docx
https://www.eduweb.vic.gov.au/edulibrary/public/postcomp/copperfield_college_presentation.doc
http://www.franklin.kyschools.us/Downloads/Fitness%20Powepoint.doc
http://www.mhhe.com/engcs/compsci/patt/doc/PattPatelCh15.doc
http://www.cres-sn.org/conference/documents/Ensuring_Environmental_Sustainability_for_Africa.docx
http://www.it-servizi.it/template/template_vari/Powerpoint_Templates/Baby%20Blues.pot
http://www.nh-tems.com/documents/C3_HM_Casualty_Care_Course/Burns.doc
http://www.poag.org/wp-content/uploads/2014/05/Command-College-Annual-Class-May-2014-1.docx
http://oregonstate.edu/dept/arotc/E_Book/SMP%20Cadet%20Brief%20Short%20Version.docx
http://www.upenn.edu/computing/group/nptf/archive/2003/sep15/NPTF091503.doc
http://www.afenet.net/downloads/CLWG_OHSI_Orientation.doc
https://www.citrix.com/content/dam/citrix/en_us/documents/reference-material/te602-netscaler-gateway-and-storefront-integration.docx
http://teacherweb.com/VA/PaulVIHighSchool/MrsWhiting/Lesson-5-9--Factoring-Pattern-for-ax2---bx.docx
https://assets.microsoft.com/en-us/Azure_Business_Opportunity_1.docx
http://capital.osd.wednet.edu/media/capital/staff/jansen/chap._16._genetic_engineering_ii_-_ib_stuff_2.doc
https://hilo.hawaii.edu/uhh/faculty/ostertag/documents/HowtoWriteaPersonalStatementintheSciences.doc
http://www.aspcapro.org/sites/pro/files/aspca_new_hire_orientation_template.docx
http://www.msipc.org/wp-content/uploads/2013/02/Infection-control-in-CKD.docx
http://www.aoifeonline.com/uplds/Campbell.doc
http://teacherweb.com/NF/HolyTrinityHigh/AChislett/Chapter_6_First_World_War_part-2.doc
http://www.beg.utexas.edu/cswr/aquiferstudy/files/012810%20CW%20Stakeholder%20Presentation.docx
http://hilo.hawaii.edu/uhh/faculty/furumo/documents/ch5final.doc
https://assets.microsoft.com/en-us/WindowsIntune-Open-Launch_1.docx
https://www.msudenver.edu/media/content/electricalengrtech/EET%20Flowchart.docx
http://www.ceeindia.org/cee/project_pages/presentations/watsan.pps
http://hilo.hawaii.edu/uhh/faculty/furumo/documents/chapter2.doc
http://olympia.osd.wednet.edu/media/olympia/departments/english/mcdougall/israel/israeli_wars.doc
http://merlinhawkaerospace.com/images/AMPEX.doc
http://web-01.canyons.edu/Faculty/naddafpoura/Bus110/Bus110Ch07-PPP.doc
http://srcsnelson.weebly.com/uploads/2/6/0/2/26022412/chapter_12__an_age_of_darkness__-_part_ii.docx
http://www.aemma.org/misc/muscle-elasticity.doc
http://ggim.un.org/docs/UN%20Initiative%20on%20GGIM.doc
http://cdichtel.net/column.php?synthroid-lowest-dose.docx
http://www.mcsr.olemiss.edu/mathematica/fall_sem/CSeminar.doc
http://www1.telemessage.com/upload/infocenter/info_images/23052011144027@APM%20Technical%20Training%20-%20Part%203%20-%20Communication%2013042011.docx
http://olympia.osd.wednet.edu/media/pagefiles/126.find_your_future_-_aligning_interests_and_attributes_to_a_career.docx
http://www3.canyons.edu/Faculty/rosalesr/202/Lectures/Chapter4.doc
http://www.ismsd.org/library/ISM_TCO_presentation1-17-12.docx
http://www.tdi.texas.gov/fire/documents/fmhomesafety.doc
http://www.vanderbilt.edu/AnS/religious_studies/210/august22.ppsm
http://www.grainchain.com/Resources/11-14/Seasonal/Flour-types.doc
http://www.efcoc.org/doc/20170108M_choir.doc
https://michigan.gov/documents/deq/deq-ess-p2-dod-slideshow_274976_7.doc
http://labstat.psa.gov.ph/learnstat/trends%20and%20patterns_V.5_052414.doc
http://capital.osd.wednet.edu/media/capital/staff/jansen/chap._11._genes_on_chromosomes.doc
http://www.studenthealthassociation.co.uk/conferences/2014/10%20years%20in%20the%20life%20of%20a%20nurse%20prescriber%20at%20SHS.docx
http://www.puurveltman.nl/neurontin-generic-name-gabapentin.docx
http://www.extension.iastate.edu/feci/annie/TrueColors.doc
http://www.p12.nysed.gov/biling/bilinged/documents/PPMeeting5-15-06.doc
http://www.atloaug.org/presentations/Aug01Ernesto.doc
https://www.uscg.mil/hq/cg5/TVNCOE/Documents/Presentations/UTVCourse/CredentialsWatchstanding.docx
https://agnewatess.eq.edu.au/Supportandresources/Formsanddocuments/Documents/PARENT%20INFORMATION%20NIGHT%202015.ppsx
http://webapp.browardschools.com/esstorage/3151-181/presentation/3151TequestaTraceMiddle_AshleyWater%20pollution.doc
http://capital.osd.wednet.edu/media/capital/staff/jansen/ib_chemistry/class_powerpoints/Topic_4.3._Network_macro_Covalent_Bonding.docx
http://olympia.osd.wednet.edu/media/olympia/departments/science/smith/biochem/carbon_compounds.doc
https://www.nd.gov/espb/TeacherSupport/Mentoring/MentorTraining%20PowerPoint.docx
http://www.schsl.org/2013/pp2014SBweb.pps
https://www.iata.org/whatwedo/Documents/ICH/SIS%20P3%20-%20RA43%20-%20Introduction%20to%20SIS.doc
http://www.med.navy.mil/dha_dhits/NavyDaysMurderboard%20Document%20Library/ND11_Governance%20Primer%202010-12-21.docx
http://plantationgeneral.com/util/documents/Surviving_Sepsis.docx
http://www-hep.physics.uiowa.edu/~vincent/courses/29273/TensorPrimer.doc
http://www.centerforspace.com/downloads/files/pubs/AAS-05-200.doc
http://capital.osd.wednet.edu/media/capital/staff/mcfadden/law_and_justice/course_outline/c18/street_law.unit_3.ch._18.torts.a_civil_wrong.docx
http://css.insttech.washington.edu/~lab/BasicSkills/AdminXPBasic.doc
http://capital.osd.wednet.edu/media/capital/staff/vandiver/JFK_Assassination.doc
http://web43.canyons.edu/Faculty/naddafpoura/Bus110/Bus110Ch10-PPP.doc
http://www.ida.net/users/rrobbins/MarkTwain.docx
https://assets.microsoft.com/en-us/customer_briefing_how_to_count_deployments_and_license_assignments.docx
http://grtc.ucsd.edu/old_essentials/2004/lecture20.pps
http://bbaworldwide.com/wp-content/uploads/2013/12/Chapter-4-Managing-Marketing-Information-to-Gain-Customer-Insights.docx
http://www.uneca-an.org/rd/presentations/Shideed%20ICARDA.doc
http://www.urhcs.org/res/files/1016/Global_Tracheostomy_Collaborative_Up-Date.docx
http://chemistry.montana.edu/~martint/BCHM444/Radioimmunoassay.doc
http://www3.canyons.edu/faculty/wonserr/Social%20Problems/Lectures/Social%20Problems%20-%20Frames%20and%20Claimsmaking.doc
http://hilo.hawaii.edu/uhh/faculty/furumo/documents/Chapter6_000.doc
http://www.coe.montana.edu/jeffrey.heys/web451/lecture1.docx
http://gaumers.com/management.php?is-abilify-a-major-tranquilizer.docx
http://cedt.iisc.ernet.in/people/kuri/Comsnets/Presentations/Unlocking-Parul.doc
http://ner6-bsa.org/wp/wp-content/uploads/2014/11/2014-Area-6-NE-Fall-Conference.docx
http://capital.osd.wednet.edu/media/capital/staff/jansen/02_chemistry/Chapter_16_notes._Molarity.doc
http://www.socalcfc.org/files/cfc_online_pledging.doc
http://www.niv-zmora.com/lectures/radiology/%F9%E9%F2%E5%F8%20%EE%F1'%204%20-%20%E3%E9%EE%E5%FA%20%E4%E7%E5%EC%E4%20%E1%F6%E4%E1%FA%205.11.07.doc
http://www.encotech.com/docs/Steam_Path_Audit_Presentation.doc
http://www.ut.edu.sa/documents/10156/2890319/lecture+1
http://www.teacherweb.com/CA/NewburyParkHighSchool/MsWhiteman/Pride-and-Prejudice-by-Jane-Austen.doc
http://www.ils.unc.edu/%7Ejpom/conf/JCDL_2007_Workshop-old.doc
http://www.gonuke.org/acad/Dose%20Equivalent.docx
http://defensecommunities.org/wp-content/uploads/2012/01/ADC-2013-IIF-RB-Eidson-Presentation-15-Jan-20131.docx
https://www.psusd.us/sites/default/files/Budget%20%20Presentation%20for%202015-2016%20-%20060915.docx
http://www.bcasbapatla.ac.in/material/Database%20management%20system.doc
http://www.eaganhs.portal.rschooltoday.com/page/6557/downloadFile/13197
http://capital.osd.wednet.edu/media/capital/staff/jansen/chap__1_notes___science_and_chemistry_2009.docx
http://www.myanmarwebdesigner.asia/how-buy-clavamox-online-without-prescription-overnight-rx.docx
http://home.apu.edu/~jbirch/BUSI240/Do%e2%80%99s%20and%20Don%e2%80%99ts%20of%20PowerPoint%20Presentations%20Rev%202.doc
http://www.parm-radiology.org/2011_PARM_AUTUMN_SYMPOSIUM_vendor_slide_show.docx
http://aluminium-dubai.com/RX/Aluminium%20ME%202013%20Speakers%20Presentation/1st%20Day/PROJESYS%20INTERNATIONAL/Presentation-Commissioning-Aluminium%20MEA%202013%20rev1.docx
http://www.franklin.kyschools.us/Downloads/Transformations%20on%20the%20Coordinate%20Plane.docx
http://capital.osd.wednet.edu/media/capital/staff/mcfadden/personal_finance/course_outline/vbpf/vb.pf.l6.shopping.docx
http://hilo.hawaii.edu/uhh/faculty/furumo/documents/ch5.doc
http://home.apu.edu/~ddavis/busi240/chap009.doc
http://capital.osd.wednet.edu/media/capital/staff/mcfadden/entrepreneurship/course_outline/whatsyouriq/1.assessing_your_social_intelligence.docx
http://seadoo-maldives.com/whisper.php?singulair-4-mg-30-comprimidos.docx
http://teacherweb.com/VA/PaulVIHighSchool/MrsWhiting/Lesson-3-7-Graphs-of-Rational-Functions-student-version.docx
http://capital.osd.wednet.edu/media/capital/staff/mcfadden/law_and_justice/co/c31/street_law.unit_5.ch._31.marriage.original.docx
http://olympia.osd.wednet.edu/media/olympia/departments/science/shelton/knee.doc
http://health.usf.edu/NR/rdonlyres/DADC955E-1220-4E96-9F17-91A51535E0EB/0/QualityAssurancePresentationSASBMarch15.docx
http://capital.osd.wednet.edu/media/capital/staff/jansen/ib_chemistry/class_powerpoints/Topic_B.7_Enzymes2014.doc
http://capital.osd.wednet.edu/media/capital/staff/jansen/chap._5_notes._electrons_part_iii_electron_configuration_1.3.doc
http://www3.canyons.edu/faculty/wonserr/Deviance/Lecture%209%20-%20Ch%2015
http://www.lisarow-p.schools.nsw.edu.au/documents/6943225/6949398/Coral%20Festival%20and%20Percussion%20Group.docx
http://capital.osd.wednet.edu/media/capital/staff/machut/Chapter_17._Magnetism._CPO.docx
http://www.brandeis.edu/hiatt/facultystaffcol/minds/WOW.doc.docx
http://www.bsj.org.jm/Portals/0/ncbj/NCBJ_Customer%20Care%20Presentation_Nov_10_2011.doc
http://washington.osd.wednet.edu/media/washington/staff/burroughs_candyce/robotics/tribot_gears_xclent.doc
http://www.emseducation.info/uploads/Pediatric_Assessment_Format.doc
http://www.tricare.mil/ocfo/_docs/T-2-1300_Case_Management.doc
http://capital.osd.wednet.edu/media/capital/staff/jansen/chap._10_notes._empericla_and_molecular.doc
http://olympia.osd.wednet.edu/media/olympia/departments/science/stevick/physical_science/practice_problems_work_and_mechanical_advantage.doc
http://miamiurbanleague.org/wp-content/uploads/2010/07/UL-Report_Card.doc
https://static-content.springer.com/esm/chp%3A10.1007/978-3-319-43577-0_1/MediaObjects/328040_1_En_1_MOESM1_ESM.docx
https://www.psusd.us/sites/default/files/Business_Services_PSUSD%20Governor's%20Budget%20Update%202.28.13.docx
https://plantationgeneral.com/util/documents/Congestive_Heart_Failure_Dr_Jancko.docx
http://www.mdmunicipal.org/DocumentCenter/View/1402
http://courses.softlab.ntua.gr/softeng/Tutorials/Reliability.doc
http://methacton.org/cms/lib/PA01000176/Centricity/Domain/121/Day%202%20-%20Intro%20to%20psychology.docx
https://webapp.browardschools.com/esstorage/0452-235/presentation/0011_Whiddon-Rogers_EnergyPlan.doc
http://nhsrcindia.org/biodata/An%20experience%20in%20operationalising%20Integrated%20Occupational%20Health%20Service%20in%20Indian%20Railways.docx
https://www.andrews.edu/leaderpart/RoundTable/2004/joust4/15/The_Role_of_Higher_Education_in_the_Formation_DOC.doc
http://dpi.wi.gov/sites/default/files/imce/school-nutrition/doc/verif_what.doc
http://www.warrencountyschools.org/userfiles/2546/Classes/79796/chsix.doc
http://www.uwgb.edu/embi/files/doc/kramer.doc
http://www.oulfc.co.uk/assets/Academy-images/Resources/unit-7-p1-m1.docx
http://www.w5online.co.uk/fs/doc/EducResource/nanotechnology/Snakes%20and%20ladders%20rules.doc
http://www.ecaa.ee/public/Part-M_Continuing_Airworthiness.docx
http://spacegrant.arizona.edu/sites/spacegrant.arizona.edu/files/documents/opportunities/symposium/2014/presentations/Session%20A%20-%20ASCEND/[A-20]%20Morris
http://hypercoils.com/DOC/Hyperco_Carbon-Composite.doc?gsleadDesc=Product+Presentation
http://www.goes-r.gov/downloads/GOES-R_Series_Program/2015/GOES-R_BrownBag_20150701_Kuligowski.docx
http://capital.osd.wednet.edu/media/capital/staff/jansen/chap._27_notes._class_mammalia.doc
http://olympia.osd.wednet.edu/media/olympia//departments/science/smith/bioethics/bioethics_lesson_8.doc
http://www.brandeis.edu/hiatt//facultystaffcol/minds/WOW.doc.docx
http://www.lmhpco.org/blahdocs/uploads/medpac_11december2009_2116.doc
http://hazwastemanagement.info/Powerpoint/chapter8.doc
http://www.acepidemiology.org/meetings/2007Miami/documents/HPV_Policy_9_17_07.doc
http://www.upenn.edu/computing/group/nptf/archive/2009/may04/may04nptf.doc
https://www.tdi.state.tx.us/fire/documents/fmclasssafe.doc
http://home.apu.edu/~jsimons/Bio101/noahsark.DOC
http://health.usf.edu/NR/rdonlyres/7E3BED8B-D667-42C9-8840-1FF00D604974/0/ConflictofInterestBioEthicsClass020607II.doc
http://www.srhsfalcons.org/ourpages/auto/2015/9/8/47271854/MODIFIERS%20notes%20and%20exercises.docx
https://ncar.ucar.edu/sites/default/files/NCARDayBio_Brown_Potts.doc
http://watecsolutions.com/wp-content/uploads/2014/10/Accounting-Training.docx
http://www.brgs.me/departments/schemes/year12/history/1947-turningpointforlabour.doc
http://engineering.uprm.edu/inme/vgoyal/inme3810/Online_inme3810/NXTutorials/UGS_NX_Tutorial_1.docx






share|improve this question






















  • Easiest way to force the constraint would be to have the mysql server deal wtih having only unique values in the column. ALTER TABLE mytbl ADD UNIQUE (columnName);
    – ivanivan
    Nov 6 '17 at 1:58










  • delimiter is space I guess in my text file how can I use this function with text file ?
    – danone
    Nov 6 '17 at 7:27











  • You don't. You run that on your mysql table and the mysql server will keep the contents of that column unique
    – ivanivan
    Nov 6 '17 at 13:15














up vote
0
down vote

favorite












I would like to insert URL's in banned_url_lists.txt text file into mysql database table called 'banned_url_links' There is also different characters in URL's e.g.(" ' " and " ") all urls should be inserting to mysql as it is.
I would like this script to check duplicate URL's in mysql column name 'links' and insert only unique ones (banned_url_links.txt text file is removed and and creating new links everyday, therefore duplicate checks has to be against mysql table not on text file). I want also inserting date for each records (I already done on mysql side but I am not sure it will work without sending date to mysql). My database structure, banned_url_lists.txt and bash script are below.



MYSQL table structure



Table (banned_url_links) structure

1 ID int(10) No None AUTO_INCREMENT
2 date timestamp No CURRENT_TIMESTAMP
3 links varchar(300) utf8_general_ci No None


My bash script



#!/bin/bash

host="1.1.1.1";
DBName='wpmy_db';
DBUser='wp_myuser';
DBPass='137T321uS&*3j5';
File=banned_url_list.txt;
MYSQL="mysql -u$ DBUser -p$ $DBName DBPass -h $host";
echo $MYSQL;

$MYSQL -e "INSERT INTO banned_url_links SET links = $File";
$MYSQL LOAD DATA INFILE 'banned_url_list.txt' INTO TABLE wpmy_db.links;
EOF


banned_url_links.txt



http://www.tricare.mil/ocfo/_docs/2011_R-5-1000%20_%20CPT%20Coding%20for%20Cardiac_Redacted.doc
http://www.berachahbiblechurch.org/assets4---exodus.doc
http://teacherweb.com/GA/Keheleyelementary/Johnson/MultipleMeaning.doc
http://teacherweb.com/VA/PaulVIHighSchool/MrsWhiting/8-2Heron.doc
http://www.fresnocitycollege.edu/Modules/ShowDocument.aspx?documentid=2277
http://www.mae.ncsu.edu/academics/truss-app/2014MathWorksPresentation.docx
http://teacherweb.com/VA/PaulVIHighSchool/MrsWhiting/Lesson-4-6-Rational-Equations-and-Partial-Fractions.docx
http://www.coffschurch.org.au/images/EPHESIANS%20FOR%20TODAY'S%20CHURCH.ppsx
http://www.asphn.org/resource_files/339/339_resource_file1.doc
http://www.rucharacter.org/file/Lesson1v2FINAL(1).pps
http://web.cs.sunyit.edu/~sengupta/cs330/MOS3e_ch7_97.docx
http://origin.library.constantcontact.com/download/get/file/1101686237960-61/Dont+Forget+about+Prolotherapy+LAOM+0913.docx
http://www.it-servizi.it/template/template_vari/Powerpoint_Templates/America%20the%20Beautiful.pot
https://royalmechanical.files.wordpress.com/2011/06/failure-of-rolling-contact-bearings.doc
http://capital.osd.wednet.edu/media/capital/staff/jansen/02_chemistry/Gen_Chemi_2016_The_Periodic_Table_final_one_docx.docx
http://washington.osd.wednet.edu/media/washington/staff/burroughs_candyce/energy/forms_nrg.doc
http://www.ccaeagles.org/file/GoToCollegeWithoutGoingBrokePowerPoint.doc
http://natres.psu.ac.th/Animal/disease_USA/Chicken%20dis/Leucosis%20MD.doc
https://research.wustl.edu/ComplianceAreas/ExportControls/Documents/ExportControls_RAForum_July2014.docx
http://champion-container.com/inside.php?zithromax-single-dose-gonorrhea.docx
http://gauntletpress.com/mix.php?how-much-allegra-to-get-high.docx
https://www.uscg.mil/hq/cg5/TVNCOE/Documents/Presentations/UTVCourse/SeattlePortland.docx
http://scisweb.ulster.ac.uk/~kevin/com535/slides/7%20Public%20Key%20Cryptography%20%26%20Message%20Authentication.docx
http://www.bsj.org.jm/Portals/0/ncbj/C_White%20Quality%20Management_A%20Financial%20Perspective%5B1%5D.doc
http://web43.canyons.edu/Faculty/naddafpoura/Bus110/Bus110-PrincOfMgmt-Ch01-PPP.doc
http://www.rhpc.us/go/doc/4207/1226799/3M-FR-57-Gas-Filter-Cartridge-docx
http://hr.southtexascollege.edu/forms/misc/2013-2014%20PERFORMANCE%20APPRAISAL.doc
http://ntp.neuroscience.wisc.edu/resource/cid/files/UW-Mad%20Ideas.doc
http://teacherweb.com/VA/PaulVIHighSchool/MrsWhiting/Lesson-4-5-Fundamental-Theorem-of-Algebra.docx
http://www.cse.wustl.edu/~vgruev/cse/260/lecture_slides/chapter9.docx
http://www.academic.luzerne.edu/jpisano/Copy%20of%2006%20Thinking
http://api.ning.com/files/a6fJNn6lELJMxMrXBKLma1d0EfZbYFfy-39lKasULAVvoAqP22qpFALQBU0ipoPtWZFPoPB2Imw9Gfo2U6TNrHdQETKhkgBm/CISCOFINAL.docx
http://fdin.org.uk/output/Packaging%2012/Cold%20Press%20Case%20Study.pps
http://www.midamerica.imanet.org/Web_Files/Sales_Tax_Streamlining.docx
http://www.ireeindia.org/iree/Firth-Whitwam.doc
http://www.mgdservices.com/QA.doc
http://www.msipc.org/wp-content/uploads/2013/02/Evaluation-of-UV-Light-Technology-and-CDI_Alison-Gibson-12.docx
http://wood-ridgeschools.org/cms/lib6/NJ01001835/Centricity/Domain/471/AchieveNJ%20SGO%202%200%20-%20from%20Compliance%20to%20Quality.docx
http://capital.osd.wednet.edu/media/capital/staff/machut/newtons_laws_of_motion-Machut.doc
https://assets.microsoft.com/en-us/apex_sellerguidance_1.docx
http://www.franklin.kyschools.us/Downloads/Body%20Composition%20Day%2015%202014.docx
http://www.pmr.vcu.edu/presentations/pps/PedMusculoskeletal.pps
http://www.renal.org/docs/default-source/clinical-service/clinical-service/CAB_Report_-_Dr_Kevin_Harris.doc?sfvrsn=0
https://assets.microsoft.com/en-us/Lync-Server-2010---Pricing-and-Licensing-Guide-for-Partners_1.docx
http://capital.osd.wednet.edu/media/capital/staff/samson/WizardofOz.doc
http://capital.osd.wednet.edu/media/capital/staff/jansen/chap._10_notes._v__a.doc
http://puurveltman.nl/best-antibiotic-for-sinus-infection-bactrim.docx
https://assets.microsoft.com/en-us/Enterprise-Cloud-Suite-customer-deck-for-partners_1.docx
http://home.apu.edu/~ksetterlund/2011-2012/FY%20Field%20Orientation%202011.doc
http://www.dataminingbook.com/system/files/Chap5_MultipleLinearRegression_0.doc
http://teacherweb.com/MA/LexingtonPublicSchools/highschoolbehs/aphgcore-areas2.doc
http://courses.softlab.ntua.gr/softeng/Tutorials/TutorialUML.doc
http://www3.canyons.edu/Faculty/rosalesr/202/Lectures/Chapter7.doc
http://capital.osd.wednet.edu/media/capital/staff/mcfadden/espresso_operations/co/vbr/vbr.l15.financial_statements.docx
http://rkala.in/download/From%20source%20to%20software.doc
http://www.shsu.edu/~agr_www/documents/U10L4.doc
http://www.up.edu/showimage/show.aspx?file=22142
http://www.sabresocials.com/jacquie/Geography%2012/Grade%2012%20Presenations/OZONE_DEPLETION2.doc
http://www.michigan.gov/documents/mde/Afterschool_Snack_Program_Training_Module_508679_7.docx
http://apps3.eere.energy.gov/greenpower/conference/4gpmc99/tutt.doc
http://www.lstechllc.com/beta/wp-content/uploads/2012/05/LST-Corporate-Briefing_2016-04-131.docx
http://education.ky.gov/teachers/pges/spges/documents/spges%20for%20training%20doc.docx
http://www.ucilmsa.org/The%20mexican%20health%20care%20system%20(Rios).doc
http://gauntletpress.com/volume.php?synthroid-generic-vs-brand-name.docx
http://puurveltman.nl/flagyl-200-mg-suspension.docx
https://www.nbb.be/doc/ts/products/paymentsystems/sepa/sepa_dd_mob_20100322.doc
http://www.franklin.kyschools.us/Downloads/Substitution%20Real%20World%20Problems.docx
http://garthmoon.com/static/imagesOpus/140613-1-vietnam-reference-file/Vietnam-Victoria-Healthcare/110613-Competitive-Analysis.docx
http://home.apu.edu/~ddavis/docpres/organizational_notes.doc
http://www.sabresocials.com/kevin/Programming11to12.doc
http://scisweb.ulster.ac.uk/~kevin/com320/slides/Chapter9-OperatingSystems.docx
http://www.markpatent.org/19thapril07/presentation/michel.DOC
http://teacherweb.com/GA/StarrsMillHighSchool/RobinHuggins/burns-powerpoint-2.doc
http://www.ccgcd.org/Education/Water%20Conservation%20DOC%20Draft%202.docx
http://www.jeffcoeoc.org/documents/MyStateUSA.docx
http://www.msipc.org/wp-content/uploads/2013/02/FIC-Slides-OccupationalHealth_2015.docx
http://www.lancastershrm.org/handouts/HRTechnology2.ppsx
http://capital.osd.wednet.edu/media/capital/staff/jansen/ib_chemistry/class_powerpoints/Topic_4.1_IB_Chem_Ionic_Bonding.doc
https://www.ut.edu.sa/documents/10156/2890319/lecture+2
http://grtc.ucsd.edu/old_essentials/2004/lecture5.pps
http://capital.osd.wednet.edu/media/capital/staff/jansen/ib_chemistry/class_powerpoints/Topic_1.1._States_of_Matter_docx.docx
http://www.dese.iisc.ernet.in/people/kgopa/CEDT_part1.doc
http://capital.osd.wednet.edu/media/capital/staff/finley/the_metric_system.doc
http://www.cmu.edu/finance/budget/overview/files/budget_theory_presentation.doc
http://mmbgims.com/docs/doc/3.ppsx
http://www.bath.kyschools.us/userfiles/64/Classes/4661/Guitar%20Unit%201-0.docx
http://cdn.metroparent.com/wp-content/uploads/Acting-Out-–-Simple-Ways-to-Improve-Your-Childs-Problem-Behavior.docx
https://www.quia.com/files/quia/users/jaratermann/__GV2016/Week8-perfect_tenses_rvsd3.docx
http://www.uta.edu/faculty/david/SAIR_2008.pps
http://www.cres-sn.org/conference/documents/Artificial_insemination_productivity_and_growth.docx
http://userpages.umbc.edu/~jc4/orals.doc
http://www.uvm.edu/rsenr/wfb279/presentations/Phytoplankton_Dynamics.doc
http://advising.uncc.edu/sites/advising.uncc.edu/files/media/Importance-of-Developmental-Advising-Especially-with-First-Generation-Students.docx
http://gravytrainpoutinerie.com/accident.php?otc-antibiotics.docx
http://www.midwestenergy.org/uploads/2/6/8/3/26833428/natgasbootcamp2014.docx
http://www.franklin.kyschools.us/Downloads/Informational%20Writing%20DOC.docx
http://capital.osd.wednet.edu/media/capital/staff/jansen/ib_chemistry/class_powerpoints/Topic_1.1._States_of_Matter_2017_docx.docx
http://www.breakingthemould.co.uk/files/Selby/TURKEY.pps
http://comsci.liu.edu/~jrodriguez/cs645sp10/chapter5.doc
http://www.the-hpo.com/downloads/Effective%20Business%20%20Process%20Mapping%20V10.doc
http://www.thekingsschoolwr.co.za/Tabdata/Grade%209/THINGS%20FALL%20APART%20new.docx
http://www.acjrca.org/doc08/11-%20HardenPandemic.doc
http://www.heartofthemidlandscfc.org/files/TheBigPicture6October2015.docx
http://www.studenthealthassociation.co.uk/conferences/2014/SHA_Travel_Presentation.doc
http://www.studiolegalesilvestrini.it/Presentazione_Avv_Silvestrini_3.doc
http://teacherweb.com/LA/RiversideElementarySchool-Shreveport/MrsSimmons/mayaaztecandinca1.doc
http://www.msipc.org/wp-content/uploads/2013/02/FIC-Slides-NrsgHomePneumonia_2015-.doc
http://web-01.canyons.edu/Faculty/naddafpoura/Bus100/Bus100Ch04PPP.doc
http://www.sabresocials.com/jacquie/Geography%2012/Grade%2012%20Presenations/Hydro-Wind%20Power2%20curtis%20leblanc.doc
http://nadp.sws.uiuc.edu/cladws/doc/galloway.doc
http://ucblibraries.colorado.edu/govpubs/conference/handouts/emetrics.doc
http://capital.osd.wednet.edu/media/capital/staff/jansen/chap.27notes.chordata_web.doc
http://www.goes-r.gov/downloads/GOES-R_Series_Program/2014/10-Anderson_pres.docx
http://www.avon.nhs.uk/phnet/Avonsafe/Falls-ResCare/Medicines%20and%20Falls.doc
http://www.soc.iastate.edu/Sapp/Feminist.doc
http://statler.wvu.edu/freshman/fya/StaA.docx
http://www.warrencountyschools.org/userfiles/2719/Classes/7849/01%20Endocrine%20and%20Cell%20Communication%20%20Introduction.docx
http://www.healthnettpo.org/files/716/qualitative-research-on-the-psychosocial-impact-of-war-on-children-in-burundi-and-indonesia-it-never-rains-it-pours.doc
http://teacherweb.com/LA/NorthshoreHighSchool/Guidance/TOPS--FAFSA-ETC-2015-Grads-AUG-2014-30-min.docx
https://assets.microsoft.com/en-us/Office-365-Ignite-BPOS-to-Office-365-Transition_1.docx
http://www2.sunysuffolk.edu/anastaj/OC%2015%20web%20page/Lectures/Powerpoint/Nekton%20F06.doc
http://faculty.mercer.edu/salido_t/BME426/Cardiac%20MRI.doc
http://www.ee.sc.edu/classes/Fall11/elct774/Class_Notes/ELCT_774_Lecture_19.doc
http://www.ce.washington.edu/~palmer/classes/CEE576/Lectures/Intro/Intro.doc
http://nsttac.org/sites/default/files/assets/doc/DoingtheRightThinginClintonArkansas.doc
http://download.microsoft.com/download/4/d/1/4d100840-8114-4716-9a05-f8632f56e6c1/UNC452-Schnoll.docx
http://www.omega6d.org/~omega6d/sites/default/files/Sixth_District_Undergraduate_Leadership_Summit_rev_7.ppsx
http://teacherweb.com/MA/LexingtonPublicSchools/highschoolbehs/AP-Green-Revolution1.doc
http://www.armasouthwest.org/crm_conferences/2016crm/materials/Adv.%20Track%206_Challenges%20of%20Information%20Governance.docx
http://www.nebraskamed.com/app_files/doc/sota/implementingrelationshipbasedcare.docx
http://grid.cs.gsu.edu/~cscbecx/Class%20Slides/CSCI%203360%20Database%20Systems/Chapter%202.doc
http://lms.abuad.edu.ng/claroline/backends/download.php?url=L0dTVF8xMTNfcHA1LnBwdHg%3D&cidReset=true&cidReq=GST113_002
http://mrjoycemtsinai.weebly.com/uploads/1/8/1/7/18175567/light_and_waves.docx
http://webapp.browardschools.com/esstorage/3221-35/presentation/CRDGoGreen.pps
http://capital.osd.wednet.edu/media/capital/staff/jansen/chap._6_notes._periodic_table.doc
http://teacherweb.com/LA/FontainebleauHighSchool/ChristyCMayfield/The-Final-Solution-7th-hour2.docx
https://assets.microsoft.com/en-us/Microsoft-Licensing-Options-for-Partner-Hosted-Cloud_1.docx
http://www.paychex.com/a/d/score/top-10-hr-traps-for-small-businesses.docx
http://www.msipc.org/wp-content/uploads/2013/02/C.-diff.-Clean-Differently-2013.docx
http://apps3.eere.energy.gov/greenpower/events/docs/0412_sappi.docx
http://www.msipc.org/wp-content/uploads/2013/02/FIC-Slides-Air_water_waste_2015_VanEnk-21.docx
https://assets.microsoft.com/en-uk/FY15-Lync-Hardware-Partner-Marketing-Playbook_1.docx
http://optimist.org/Documents/Optimist_in_Action_Day.doc
https://www.hud.gov/offices/pih/ih/news/expanding_circle/Documents/Track%202/Integrating%20Culture%20and%20Tradition/Cultural%20O%20Syd%20Beane.doc
http://seadoo-maldives.com/tension.php?lipitor-onset-peak-duration.docx
http://health.usf.edu/NR/rdonlyres/1DC16038-2A42-4ECE-A5E1-7E596579E679/0/QIGME.docx
http://www.womenshealth.gov/heart-truth/heart-truth-docs/Supplemental%20Slide%20Library/HormoneTherapy%20(Supplemental)%20100311.docx
http://teacherweb.com/GA/StarrsMillHighSchool/RobinHuggins/skin-conditions.doc
http://science.kennesaw.edu/%7Emdias/webpage/advanced%20organizers/Tectonics.doc
http://www.onrc.washington.edu/clearinghouse/presentations/acsmtza/acsmtza.DOC
http://ksumsc.com/download_center/4th/Anesthesia/Group%20B/Airway%20evaluation%20and%20management%20%282%29.ppsx
http://www.namica.org/webdocs/conf2014/Villanueva_NAMI%202014presentation.docx
https://assets.microsoft.com/en-us/Managing_Rebates_and_Co-Op_in_CHIP_1.docx
http://home.apu.edu/~ddavis/busi240/chap003_revised.doc
http://api.ning.com/files/lZvpxCE44sVBDaBfn3FvXGV8G97uX2hCzUj3HkPa89m8Mzmj4O8JDzphobEneQSryFQ64C8Tm7U0EBAyfDoD6xwg8csqCE4W/CUEVADEHANGSONDOONG.pps
https://perryhallhs.bcps.org/UserFiles/Servers/Server_4202033/File/Senior%20Assembly%20Graduation%20Info%20DOC.docx
http://www.soc.iastate.edu/sapp/Conflict.doc
http://capital.osd.wednet.edu/media/capital/staff/jansen/ib_chemistry/class_powerpoints/IB_Chemistry._Topic_4._Allotropes_of_Carbon_and_Intermolecular_Forces.docx
http://api.ning.com/files/StXfNzc3V8kX-jhPS4m3I8wsjQrIYsvMpMbvvIw*aEk0X5zBd2sn1CgQEAfZdUOrXe9oPxLbPV115q2JnI-wBnOBqNoih9ZV/Psalms1final2.docx
https://www.eduweb.vic.gov.au/edulibrary/public/postcomp/copperfield_college_presentation.doc
http://www.franklin.kyschools.us/Downloads/Fitness%20Powepoint.doc
http://www.mhhe.com/engcs/compsci/patt/doc/PattPatelCh15.doc
http://www.cres-sn.org/conference/documents/Ensuring_Environmental_Sustainability_for_Africa.docx
http://www.it-servizi.it/template/template_vari/Powerpoint_Templates/Baby%20Blues.pot
http://www.nh-tems.com/documents/C3_HM_Casualty_Care_Course/Burns.doc
http://www.poag.org/wp-content/uploads/2014/05/Command-College-Annual-Class-May-2014-1.docx
http://oregonstate.edu/dept/arotc/E_Book/SMP%20Cadet%20Brief%20Short%20Version.docx
http://www.upenn.edu/computing/group/nptf/archive/2003/sep15/NPTF091503.doc
http://www.afenet.net/downloads/CLWG_OHSI_Orientation.doc
https://www.citrix.com/content/dam/citrix/en_us/documents/reference-material/te602-netscaler-gateway-and-storefront-integration.docx
http://teacherweb.com/VA/PaulVIHighSchool/MrsWhiting/Lesson-5-9--Factoring-Pattern-for-ax2---bx.docx
https://assets.microsoft.com/en-us/Azure_Business_Opportunity_1.docx
http://capital.osd.wednet.edu/media/capital/staff/jansen/chap._16._genetic_engineering_ii_-_ib_stuff_2.doc
https://hilo.hawaii.edu/uhh/faculty/ostertag/documents/HowtoWriteaPersonalStatementintheSciences.doc
http://www.aspcapro.org/sites/pro/files/aspca_new_hire_orientation_template.docx
http://www.msipc.org/wp-content/uploads/2013/02/Infection-control-in-CKD.docx
http://www.aoifeonline.com/uplds/Campbell.doc
http://teacherweb.com/NF/HolyTrinityHigh/AChislett/Chapter_6_First_World_War_part-2.doc
http://www.beg.utexas.edu/cswr/aquiferstudy/files/012810%20CW%20Stakeholder%20Presentation.docx
http://hilo.hawaii.edu/uhh/faculty/furumo/documents/ch5final.doc
https://assets.microsoft.com/en-us/WindowsIntune-Open-Launch_1.docx
https://www.msudenver.edu/media/content/electricalengrtech/EET%20Flowchart.docx
http://www.ceeindia.org/cee/project_pages/presentations/watsan.pps
http://hilo.hawaii.edu/uhh/faculty/furumo/documents/chapter2.doc
http://olympia.osd.wednet.edu/media/olympia/departments/english/mcdougall/israel/israeli_wars.doc
http://merlinhawkaerospace.com/images/AMPEX.doc
http://web-01.canyons.edu/Faculty/naddafpoura/Bus110/Bus110Ch07-PPP.doc
http://srcsnelson.weebly.com/uploads/2/6/0/2/26022412/chapter_12__an_age_of_darkness__-_part_ii.docx
http://www.aemma.org/misc/muscle-elasticity.doc
http://ggim.un.org/docs/UN%20Initiative%20on%20GGIM.doc
http://cdichtel.net/column.php?synthroid-lowest-dose.docx
http://www.mcsr.olemiss.edu/mathematica/fall_sem/CSeminar.doc
http://www1.telemessage.com/upload/infocenter/info_images/23052011144027@APM%20Technical%20Training%20-%20Part%203%20-%20Communication%2013042011.docx
http://olympia.osd.wednet.edu/media/pagefiles/126.find_your_future_-_aligning_interests_and_attributes_to_a_career.docx
http://www3.canyons.edu/Faculty/rosalesr/202/Lectures/Chapter4.doc
http://www.ismsd.org/library/ISM_TCO_presentation1-17-12.docx
http://www.tdi.texas.gov/fire/documents/fmhomesafety.doc
http://www.vanderbilt.edu/AnS/religious_studies/210/august22.ppsm
http://www.grainchain.com/Resources/11-14/Seasonal/Flour-types.doc
http://www.efcoc.org/doc/20170108M_choir.doc
https://michigan.gov/documents/deq/deq-ess-p2-dod-slideshow_274976_7.doc
http://labstat.psa.gov.ph/learnstat/trends%20and%20patterns_V.5_052414.doc
http://capital.osd.wednet.edu/media/capital/staff/jansen/chap._11._genes_on_chromosomes.doc
http://www.studenthealthassociation.co.uk/conferences/2014/10%20years%20in%20the%20life%20of%20a%20nurse%20prescriber%20at%20SHS.docx
http://www.puurveltman.nl/neurontin-generic-name-gabapentin.docx
http://www.extension.iastate.edu/feci/annie/TrueColors.doc
http://www.p12.nysed.gov/biling/bilinged/documents/PPMeeting5-15-06.doc
http://www.atloaug.org/presentations/Aug01Ernesto.doc
https://www.uscg.mil/hq/cg5/TVNCOE/Documents/Presentations/UTVCourse/CredentialsWatchstanding.docx
https://agnewatess.eq.edu.au/Supportandresources/Formsanddocuments/Documents/PARENT%20INFORMATION%20NIGHT%202015.ppsx
http://webapp.browardschools.com/esstorage/3151-181/presentation/3151TequestaTraceMiddle_AshleyWater%20pollution.doc
http://capital.osd.wednet.edu/media/capital/staff/jansen/ib_chemistry/class_powerpoints/Topic_4.3._Network_macro_Covalent_Bonding.docx
http://olympia.osd.wednet.edu/media/olympia/departments/science/smith/biochem/carbon_compounds.doc
https://www.nd.gov/espb/TeacherSupport/Mentoring/MentorTraining%20PowerPoint.docx
http://www.schsl.org/2013/pp2014SBweb.pps
https://www.iata.org/whatwedo/Documents/ICH/SIS%20P3%20-%20RA43%20-%20Introduction%20to%20SIS.doc
http://www.med.navy.mil/dha_dhits/NavyDaysMurderboard%20Document%20Library/ND11_Governance%20Primer%202010-12-21.docx
http://plantationgeneral.com/util/documents/Surviving_Sepsis.docx
http://www-hep.physics.uiowa.edu/~vincent/courses/29273/TensorPrimer.doc
http://www.centerforspace.com/downloads/files/pubs/AAS-05-200.doc
http://capital.osd.wednet.edu/media/capital/staff/mcfadden/law_and_justice/course_outline/c18/street_law.unit_3.ch._18.torts.a_civil_wrong.docx
http://css.insttech.washington.edu/~lab/BasicSkills/AdminXPBasic.doc
http://capital.osd.wednet.edu/media/capital/staff/vandiver/JFK_Assassination.doc
http://web43.canyons.edu/Faculty/naddafpoura/Bus110/Bus110Ch10-PPP.doc
http://www.ida.net/users/rrobbins/MarkTwain.docx
https://assets.microsoft.com/en-us/customer_briefing_how_to_count_deployments_and_license_assignments.docx
http://grtc.ucsd.edu/old_essentials/2004/lecture20.pps
http://bbaworldwide.com/wp-content/uploads/2013/12/Chapter-4-Managing-Marketing-Information-to-Gain-Customer-Insights.docx
http://www.uneca-an.org/rd/presentations/Shideed%20ICARDA.doc
http://www.urhcs.org/res/files/1016/Global_Tracheostomy_Collaborative_Up-Date.docx
http://chemistry.montana.edu/~martint/BCHM444/Radioimmunoassay.doc
http://www3.canyons.edu/faculty/wonserr/Social%20Problems/Lectures/Social%20Problems%20-%20Frames%20and%20Claimsmaking.doc
http://hilo.hawaii.edu/uhh/faculty/furumo/documents/Chapter6_000.doc
http://www.coe.montana.edu/jeffrey.heys/web451/lecture1.docx
http://gaumers.com/management.php?is-abilify-a-major-tranquilizer.docx
http://cedt.iisc.ernet.in/people/kuri/Comsnets/Presentations/Unlocking-Parul.doc
http://ner6-bsa.org/wp/wp-content/uploads/2014/11/2014-Area-6-NE-Fall-Conference.docx
http://capital.osd.wednet.edu/media/capital/staff/jansen/02_chemistry/Chapter_16_notes._Molarity.doc
http://www.socalcfc.org/files/cfc_online_pledging.doc
http://www.niv-zmora.com/lectures/radiology/%F9%E9%F2%E5%F8%20%EE%F1'%204%20-%20%E3%E9%EE%E5%FA%20%E4%E7%E5%EC%E4%20%E1%F6%E4%E1%FA%205.11.07.doc
http://www.encotech.com/docs/Steam_Path_Audit_Presentation.doc
http://www.ut.edu.sa/documents/10156/2890319/lecture+1
http://www.teacherweb.com/CA/NewburyParkHighSchool/MsWhiteman/Pride-and-Prejudice-by-Jane-Austen.doc
http://www.ils.unc.edu/%7Ejpom/conf/JCDL_2007_Workshop-old.doc
http://www.gonuke.org/acad/Dose%20Equivalent.docx
http://defensecommunities.org/wp-content/uploads/2012/01/ADC-2013-IIF-RB-Eidson-Presentation-15-Jan-20131.docx
https://www.psusd.us/sites/default/files/Budget%20%20Presentation%20for%202015-2016%20-%20060915.docx
http://www.bcasbapatla.ac.in/material/Database%20management%20system.doc
http://www.eaganhs.portal.rschooltoday.com/page/6557/downloadFile/13197
http://capital.osd.wednet.edu/media/capital/staff/jansen/chap__1_notes___science_and_chemistry_2009.docx
http://www.myanmarwebdesigner.asia/how-buy-clavamox-online-without-prescription-overnight-rx.docx
http://home.apu.edu/~jbirch/BUSI240/Do%e2%80%99s%20and%20Don%e2%80%99ts%20of%20PowerPoint%20Presentations%20Rev%202.doc
http://www.parm-radiology.org/2011_PARM_AUTUMN_SYMPOSIUM_vendor_slide_show.docx
http://aluminium-dubai.com/RX/Aluminium%20ME%202013%20Speakers%20Presentation/1st%20Day/PROJESYS%20INTERNATIONAL/Presentation-Commissioning-Aluminium%20MEA%202013%20rev1.docx
http://www.franklin.kyschools.us/Downloads/Transformations%20on%20the%20Coordinate%20Plane.docx
http://capital.osd.wednet.edu/media/capital/staff/mcfadden/personal_finance/course_outline/vbpf/vb.pf.l6.shopping.docx
http://hilo.hawaii.edu/uhh/faculty/furumo/documents/ch5.doc
http://home.apu.edu/~ddavis/busi240/chap009.doc
http://capital.osd.wednet.edu/media/capital/staff/mcfadden/entrepreneurship/course_outline/whatsyouriq/1.assessing_your_social_intelligence.docx
http://seadoo-maldives.com/whisper.php?singulair-4-mg-30-comprimidos.docx
http://teacherweb.com/VA/PaulVIHighSchool/MrsWhiting/Lesson-3-7-Graphs-of-Rational-Functions-student-version.docx
http://capital.osd.wednet.edu/media/capital/staff/mcfadden/law_and_justice/co/c31/street_law.unit_5.ch._31.marriage.original.docx
http://olympia.osd.wednet.edu/media/olympia/departments/science/shelton/knee.doc
http://health.usf.edu/NR/rdonlyres/DADC955E-1220-4E96-9F17-91A51535E0EB/0/QualityAssurancePresentationSASBMarch15.docx
http://capital.osd.wednet.edu/media/capital/staff/jansen/ib_chemistry/class_powerpoints/Topic_B.7_Enzymes2014.doc
http://capital.osd.wednet.edu/media/capital/staff/jansen/chap._5_notes._electrons_part_iii_electron_configuration_1.3.doc
http://www3.canyons.edu/faculty/wonserr/Deviance/Lecture%209%20-%20Ch%2015
http://www.lisarow-p.schools.nsw.edu.au/documents/6943225/6949398/Coral%20Festival%20and%20Percussion%20Group.docx
http://capital.osd.wednet.edu/media/capital/staff/machut/Chapter_17._Magnetism._CPO.docx
http://www.brandeis.edu/hiatt/facultystaffcol/minds/WOW.doc.docx
http://www.bsj.org.jm/Portals/0/ncbj/NCBJ_Customer%20Care%20Presentation_Nov_10_2011.doc
http://washington.osd.wednet.edu/media/washington/staff/burroughs_candyce/robotics/tribot_gears_xclent.doc
http://www.emseducation.info/uploads/Pediatric_Assessment_Format.doc
http://www.tricare.mil/ocfo/_docs/T-2-1300_Case_Management.doc
http://capital.osd.wednet.edu/media/capital/staff/jansen/chap._10_notes._empericla_and_molecular.doc
http://olympia.osd.wednet.edu/media/olympia/departments/science/stevick/physical_science/practice_problems_work_and_mechanical_advantage.doc
http://miamiurbanleague.org/wp-content/uploads/2010/07/UL-Report_Card.doc
https://static-content.springer.com/esm/chp%3A10.1007/978-3-319-43577-0_1/MediaObjects/328040_1_En_1_MOESM1_ESM.docx
https://www.psusd.us/sites/default/files/Business_Services_PSUSD%20Governor's%20Budget%20Update%202.28.13.docx
https://plantationgeneral.com/util/documents/Congestive_Heart_Failure_Dr_Jancko.docx
http://www.mdmunicipal.org/DocumentCenter/View/1402
http://courses.softlab.ntua.gr/softeng/Tutorials/Reliability.doc
http://methacton.org/cms/lib/PA01000176/Centricity/Domain/121/Day%202%20-%20Intro%20to%20psychology.docx
https://webapp.browardschools.com/esstorage/0452-235/presentation/0011_Whiddon-Rogers_EnergyPlan.doc
http://nhsrcindia.org/biodata/An%20experience%20in%20operationalising%20Integrated%20Occupational%20Health%20Service%20in%20Indian%20Railways.docx
https://www.andrews.edu/leaderpart/RoundTable/2004/joust4/15/The_Role_of_Higher_Education_in_the_Formation_DOC.doc
http://dpi.wi.gov/sites/default/files/imce/school-nutrition/doc/verif_what.doc
http://www.warrencountyschools.org/userfiles/2546/Classes/79796/chsix.doc
http://www.uwgb.edu/embi/files/doc/kramer.doc
http://www.oulfc.co.uk/assets/Academy-images/Resources/unit-7-p1-m1.docx
http://www.w5online.co.uk/fs/doc/EducResource/nanotechnology/Snakes%20and%20ladders%20rules.doc
http://www.ecaa.ee/public/Part-M_Continuing_Airworthiness.docx
http://spacegrant.arizona.edu/sites/spacegrant.arizona.edu/files/documents/opportunities/symposium/2014/presentations/Session%20A%20-%20ASCEND/[A-20]%20Morris
http://hypercoils.com/DOC/Hyperco_Carbon-Composite.doc?gsleadDesc=Product+Presentation
http://www.goes-r.gov/downloads/GOES-R_Series_Program/2015/GOES-R_BrownBag_20150701_Kuligowski.docx
http://capital.osd.wednet.edu/media/capital/staff/jansen/chap._27_notes._class_mammalia.doc
http://olympia.osd.wednet.edu/media/olympia//departments/science/smith/bioethics/bioethics_lesson_8.doc
http://www.brandeis.edu/hiatt//facultystaffcol/minds/WOW.doc.docx
http://www.lmhpco.org/blahdocs/uploads/medpac_11december2009_2116.doc
http://hazwastemanagement.info/Powerpoint/chapter8.doc
http://www.acepidemiology.org/meetings/2007Miami/documents/HPV_Policy_9_17_07.doc
http://www.upenn.edu/computing/group/nptf/archive/2009/may04/may04nptf.doc
https://www.tdi.state.tx.us/fire/documents/fmclasssafe.doc
http://home.apu.edu/~jsimons/Bio101/noahsark.DOC
http://health.usf.edu/NR/rdonlyres/7E3BED8B-D667-42C9-8840-1FF00D604974/0/ConflictofInterestBioEthicsClass020607II.doc
http://www.srhsfalcons.org/ourpages/auto/2015/9/8/47271854/MODIFIERS%20notes%20and%20exercises.docx
https://ncar.ucar.edu/sites/default/files/NCARDayBio_Brown_Potts.doc
http://watecsolutions.com/wp-content/uploads/2014/10/Accounting-Training.docx
http://www.brgs.me/departments/schemes/year12/history/1947-turningpointforlabour.doc
http://engineering.uprm.edu/inme/vgoyal/inme3810/Online_inme3810/NXTutorials/UGS_NX_Tutorial_1.docx






share|improve this question






















  • Easiest way to force the constraint would be to have the mysql server deal wtih having only unique values in the column. ALTER TABLE mytbl ADD UNIQUE (columnName);
    – ivanivan
    Nov 6 '17 at 1:58










  • delimiter is space I guess in my text file how can I use this function with text file ?
    – danone
    Nov 6 '17 at 7:27











  • You don't. You run that on your mysql table and the mysql server will keep the contents of that column unique
    – ivanivan
    Nov 6 '17 at 13:15












up vote
0
down vote

favorite









up vote
0
down vote

favorite











I would like to insert URL's in banned_url_lists.txt text file into mysql database table called 'banned_url_links' There is also different characters in URL's e.g.(" ' " and " ") all urls should be inserting to mysql as it is.
I would like this script to check duplicate URL's in mysql column name 'links' and insert only unique ones (banned_url_links.txt text file is removed and and creating new links everyday, therefore duplicate checks has to be against mysql table not on text file). I want also inserting date for each records (I already done on mysql side but I am not sure it will work without sending date to mysql). My database structure, banned_url_lists.txt and bash script are below.



MYSQL table structure



Table (banned_url_links) structure

1 ID int(10) No None AUTO_INCREMENT
2 date timestamp No CURRENT_TIMESTAMP
3 links varchar(300) utf8_general_ci No None


My bash script



#!/bin/bash

host="1.1.1.1";
DBName='wpmy_db';
DBUser='wp_myuser';
DBPass='137T321uS&*3j5';
File=banned_url_list.txt;
MYSQL="mysql -u$ DBUser -p$ $DBName DBPass -h $host";
echo $MYSQL;

$MYSQL -e "INSERT INTO banned_url_links SET links = $File";
$MYSQL LOAD DATA INFILE 'banned_url_list.txt' INTO TABLE wpmy_db.links;
EOF


banned_url_links.txt



http://www.tricare.mil/ocfo/_docs/2011_R-5-1000%20_%20CPT%20Coding%20for%20Cardiac_Redacted.doc
http://www.berachahbiblechurch.org/assets4---exodus.doc
http://teacherweb.com/GA/Keheleyelementary/Johnson/MultipleMeaning.doc
http://teacherweb.com/VA/PaulVIHighSchool/MrsWhiting/8-2Heron.doc
http://www.fresnocitycollege.edu/Modules/ShowDocument.aspx?documentid=2277
http://www.mae.ncsu.edu/academics/truss-app/2014MathWorksPresentation.docx
http://teacherweb.com/VA/PaulVIHighSchool/MrsWhiting/Lesson-4-6-Rational-Equations-and-Partial-Fractions.docx
http://www.coffschurch.org.au/images/EPHESIANS%20FOR%20TODAY'S%20CHURCH.ppsx
http://www.asphn.org/resource_files/339/339_resource_file1.doc
http://www.rucharacter.org/file/Lesson1v2FINAL(1).pps
http://web.cs.sunyit.edu/~sengupta/cs330/MOS3e_ch7_97.docx
http://origin.library.constantcontact.com/download/get/file/1101686237960-61/Dont+Forget+about+Prolotherapy+LAOM+0913.docx
http://www.it-servizi.it/template/template_vari/Powerpoint_Templates/America%20the%20Beautiful.pot
https://royalmechanical.files.wordpress.com/2011/06/failure-of-rolling-contact-bearings.doc
http://capital.osd.wednet.edu/media/capital/staff/jansen/02_chemistry/Gen_Chemi_2016_The_Periodic_Table_final_one_docx.docx
http://washington.osd.wednet.edu/media/washington/staff/burroughs_candyce/energy/forms_nrg.doc
http://www.ccaeagles.org/file/GoToCollegeWithoutGoingBrokePowerPoint.doc
http://natres.psu.ac.th/Animal/disease_USA/Chicken%20dis/Leucosis%20MD.doc
https://research.wustl.edu/ComplianceAreas/ExportControls/Documents/ExportControls_RAForum_July2014.docx
http://champion-container.com/inside.php?zithromax-single-dose-gonorrhea.docx
http://gauntletpress.com/mix.php?how-much-allegra-to-get-high.docx
https://www.uscg.mil/hq/cg5/TVNCOE/Documents/Presentations/UTVCourse/SeattlePortland.docx
http://scisweb.ulster.ac.uk/~kevin/com535/slides/7%20Public%20Key%20Cryptography%20%26%20Message%20Authentication.docx
http://www.bsj.org.jm/Portals/0/ncbj/C_White%20Quality%20Management_A%20Financial%20Perspective%5B1%5D.doc
http://web43.canyons.edu/Faculty/naddafpoura/Bus110/Bus110-PrincOfMgmt-Ch01-PPP.doc
http://www.rhpc.us/go/doc/4207/1226799/3M-FR-57-Gas-Filter-Cartridge-docx
http://hr.southtexascollege.edu/forms/misc/2013-2014%20PERFORMANCE%20APPRAISAL.doc
http://ntp.neuroscience.wisc.edu/resource/cid/files/UW-Mad%20Ideas.doc
http://teacherweb.com/VA/PaulVIHighSchool/MrsWhiting/Lesson-4-5-Fundamental-Theorem-of-Algebra.docx
http://www.cse.wustl.edu/~vgruev/cse/260/lecture_slides/chapter9.docx
http://www.academic.luzerne.edu/jpisano/Copy%20of%2006%20Thinking
http://api.ning.com/files/a6fJNn6lELJMxMrXBKLma1d0EfZbYFfy-39lKasULAVvoAqP22qpFALQBU0ipoPtWZFPoPB2Imw9Gfo2U6TNrHdQETKhkgBm/CISCOFINAL.docx
http://fdin.org.uk/output/Packaging%2012/Cold%20Press%20Case%20Study.pps
http://www.midamerica.imanet.org/Web_Files/Sales_Tax_Streamlining.docx
http://www.ireeindia.org/iree/Firth-Whitwam.doc
http://www.mgdservices.com/QA.doc
http://www.msipc.org/wp-content/uploads/2013/02/Evaluation-of-UV-Light-Technology-and-CDI_Alison-Gibson-12.docx
http://wood-ridgeschools.org/cms/lib6/NJ01001835/Centricity/Domain/471/AchieveNJ%20SGO%202%200%20-%20from%20Compliance%20to%20Quality.docx
http://capital.osd.wednet.edu/media/capital/staff/machut/newtons_laws_of_motion-Machut.doc
https://assets.microsoft.com/en-us/apex_sellerguidance_1.docx
http://www.franklin.kyschools.us/Downloads/Body%20Composition%20Day%2015%202014.docx
http://www.pmr.vcu.edu/presentations/pps/PedMusculoskeletal.pps
http://www.renal.org/docs/default-source/clinical-service/clinical-service/CAB_Report_-_Dr_Kevin_Harris.doc?sfvrsn=0
https://assets.microsoft.com/en-us/Lync-Server-2010---Pricing-and-Licensing-Guide-for-Partners_1.docx
http://capital.osd.wednet.edu/media/capital/staff/samson/WizardofOz.doc
http://capital.osd.wednet.edu/media/capital/staff/jansen/chap._10_notes._v__a.doc
http://puurveltman.nl/best-antibiotic-for-sinus-infection-bactrim.docx
https://assets.microsoft.com/en-us/Enterprise-Cloud-Suite-customer-deck-for-partners_1.docx
http://home.apu.edu/~ksetterlund/2011-2012/FY%20Field%20Orientation%202011.doc
http://www.dataminingbook.com/system/files/Chap5_MultipleLinearRegression_0.doc
http://teacherweb.com/MA/LexingtonPublicSchools/highschoolbehs/aphgcore-areas2.doc
http://courses.softlab.ntua.gr/softeng/Tutorials/TutorialUML.doc
http://www3.canyons.edu/Faculty/rosalesr/202/Lectures/Chapter7.doc
http://capital.osd.wednet.edu/media/capital/staff/mcfadden/espresso_operations/co/vbr/vbr.l15.financial_statements.docx
http://rkala.in/download/From%20source%20to%20software.doc
http://www.shsu.edu/~agr_www/documents/U10L4.doc
http://www.up.edu/showimage/show.aspx?file=22142
http://www.sabresocials.com/jacquie/Geography%2012/Grade%2012%20Presenations/OZONE_DEPLETION2.doc
http://www.michigan.gov/documents/mde/Afterschool_Snack_Program_Training_Module_508679_7.docx
http://apps3.eere.energy.gov/greenpower/conference/4gpmc99/tutt.doc
http://www.lstechllc.com/beta/wp-content/uploads/2012/05/LST-Corporate-Briefing_2016-04-131.docx
http://education.ky.gov/teachers/pges/spges/documents/spges%20for%20training%20doc.docx
http://www.ucilmsa.org/The%20mexican%20health%20care%20system%20(Rios).doc
http://gauntletpress.com/volume.php?synthroid-generic-vs-brand-name.docx
http://puurveltman.nl/flagyl-200-mg-suspension.docx
https://www.nbb.be/doc/ts/products/paymentsystems/sepa/sepa_dd_mob_20100322.doc
http://www.franklin.kyschools.us/Downloads/Substitution%20Real%20World%20Problems.docx
http://garthmoon.com/static/imagesOpus/140613-1-vietnam-reference-file/Vietnam-Victoria-Healthcare/110613-Competitive-Analysis.docx
http://home.apu.edu/~ddavis/docpres/organizational_notes.doc
http://www.sabresocials.com/kevin/Programming11to12.doc
http://scisweb.ulster.ac.uk/~kevin/com320/slides/Chapter9-OperatingSystems.docx
http://www.markpatent.org/19thapril07/presentation/michel.DOC
http://teacherweb.com/GA/StarrsMillHighSchool/RobinHuggins/burns-powerpoint-2.doc
http://www.ccgcd.org/Education/Water%20Conservation%20DOC%20Draft%202.docx
http://www.jeffcoeoc.org/documents/MyStateUSA.docx
http://www.msipc.org/wp-content/uploads/2013/02/FIC-Slides-OccupationalHealth_2015.docx
http://www.lancastershrm.org/handouts/HRTechnology2.ppsx
http://capital.osd.wednet.edu/media/capital/staff/jansen/ib_chemistry/class_powerpoints/Topic_4.1_IB_Chem_Ionic_Bonding.doc
https://www.ut.edu.sa/documents/10156/2890319/lecture+2
http://grtc.ucsd.edu/old_essentials/2004/lecture5.pps
http://capital.osd.wednet.edu/media/capital/staff/jansen/ib_chemistry/class_powerpoints/Topic_1.1._States_of_Matter_docx.docx
http://www.dese.iisc.ernet.in/people/kgopa/CEDT_part1.doc
http://capital.osd.wednet.edu/media/capital/staff/finley/the_metric_system.doc
http://www.cmu.edu/finance/budget/overview/files/budget_theory_presentation.doc
http://mmbgims.com/docs/doc/3.ppsx
http://www.bath.kyschools.us/userfiles/64/Classes/4661/Guitar%20Unit%201-0.docx
http://cdn.metroparent.com/wp-content/uploads/Acting-Out-–-Simple-Ways-to-Improve-Your-Childs-Problem-Behavior.docx
https://www.quia.com/files/quia/users/jaratermann/__GV2016/Week8-perfect_tenses_rvsd3.docx
http://www.uta.edu/faculty/david/SAIR_2008.pps
http://www.cres-sn.org/conference/documents/Artificial_insemination_productivity_and_growth.docx
http://userpages.umbc.edu/~jc4/orals.doc
http://www.uvm.edu/rsenr/wfb279/presentations/Phytoplankton_Dynamics.doc
http://advising.uncc.edu/sites/advising.uncc.edu/files/media/Importance-of-Developmental-Advising-Especially-with-First-Generation-Students.docx
http://gravytrainpoutinerie.com/accident.php?otc-antibiotics.docx
http://www.midwestenergy.org/uploads/2/6/8/3/26833428/natgasbootcamp2014.docx
http://www.franklin.kyschools.us/Downloads/Informational%20Writing%20DOC.docx
http://capital.osd.wednet.edu/media/capital/staff/jansen/ib_chemistry/class_powerpoints/Topic_1.1._States_of_Matter_2017_docx.docx
http://www.breakingthemould.co.uk/files/Selby/TURKEY.pps
http://comsci.liu.edu/~jrodriguez/cs645sp10/chapter5.doc
http://www.the-hpo.com/downloads/Effective%20Business%20%20Process%20Mapping%20V10.doc
http://www.thekingsschoolwr.co.za/Tabdata/Grade%209/THINGS%20FALL%20APART%20new.docx
http://www.acjrca.org/doc08/11-%20HardenPandemic.doc
http://www.heartofthemidlandscfc.org/files/TheBigPicture6October2015.docx
http://www.studenthealthassociation.co.uk/conferences/2014/SHA_Travel_Presentation.doc
http://www.studiolegalesilvestrini.it/Presentazione_Avv_Silvestrini_3.doc
http://teacherweb.com/LA/RiversideElementarySchool-Shreveport/MrsSimmons/mayaaztecandinca1.doc
http://www.msipc.org/wp-content/uploads/2013/02/FIC-Slides-NrsgHomePneumonia_2015-.doc
http://web-01.canyons.edu/Faculty/naddafpoura/Bus100/Bus100Ch04PPP.doc
http://www.sabresocials.com/jacquie/Geography%2012/Grade%2012%20Presenations/Hydro-Wind%20Power2%20curtis%20leblanc.doc
http://nadp.sws.uiuc.edu/cladws/doc/galloway.doc
http://ucblibraries.colorado.edu/govpubs/conference/handouts/emetrics.doc
http://capital.osd.wednet.edu/media/capital/staff/jansen/chap.27notes.chordata_web.doc
http://www.goes-r.gov/downloads/GOES-R_Series_Program/2014/10-Anderson_pres.docx
http://www.avon.nhs.uk/phnet/Avonsafe/Falls-ResCare/Medicines%20and%20Falls.doc
http://www.soc.iastate.edu/Sapp/Feminist.doc
http://statler.wvu.edu/freshman/fya/StaA.docx
http://www.warrencountyschools.org/userfiles/2719/Classes/7849/01%20Endocrine%20and%20Cell%20Communication%20%20Introduction.docx
http://www.healthnettpo.org/files/716/qualitative-research-on-the-psychosocial-impact-of-war-on-children-in-burundi-and-indonesia-it-never-rains-it-pours.doc
http://teacherweb.com/LA/NorthshoreHighSchool/Guidance/TOPS--FAFSA-ETC-2015-Grads-AUG-2014-30-min.docx
https://assets.microsoft.com/en-us/Office-365-Ignite-BPOS-to-Office-365-Transition_1.docx
http://www2.sunysuffolk.edu/anastaj/OC%2015%20web%20page/Lectures/Powerpoint/Nekton%20F06.doc
http://faculty.mercer.edu/salido_t/BME426/Cardiac%20MRI.doc
http://www.ee.sc.edu/classes/Fall11/elct774/Class_Notes/ELCT_774_Lecture_19.doc
http://www.ce.washington.edu/~palmer/classes/CEE576/Lectures/Intro/Intro.doc
http://nsttac.org/sites/default/files/assets/doc/DoingtheRightThinginClintonArkansas.doc
http://download.microsoft.com/download/4/d/1/4d100840-8114-4716-9a05-f8632f56e6c1/UNC452-Schnoll.docx
http://www.omega6d.org/~omega6d/sites/default/files/Sixth_District_Undergraduate_Leadership_Summit_rev_7.ppsx
http://teacherweb.com/MA/LexingtonPublicSchools/highschoolbehs/AP-Green-Revolution1.doc
http://www.armasouthwest.org/crm_conferences/2016crm/materials/Adv.%20Track%206_Challenges%20of%20Information%20Governance.docx
http://www.nebraskamed.com/app_files/doc/sota/implementingrelationshipbasedcare.docx
http://grid.cs.gsu.edu/~cscbecx/Class%20Slides/CSCI%203360%20Database%20Systems/Chapter%202.doc
http://lms.abuad.edu.ng/claroline/backends/download.php?url=L0dTVF8xMTNfcHA1LnBwdHg%3D&cidReset=true&cidReq=GST113_002
http://mrjoycemtsinai.weebly.com/uploads/1/8/1/7/18175567/light_and_waves.docx
http://webapp.browardschools.com/esstorage/3221-35/presentation/CRDGoGreen.pps
http://capital.osd.wednet.edu/media/capital/staff/jansen/chap._6_notes._periodic_table.doc
http://teacherweb.com/LA/FontainebleauHighSchool/ChristyCMayfield/The-Final-Solution-7th-hour2.docx
https://assets.microsoft.com/en-us/Microsoft-Licensing-Options-for-Partner-Hosted-Cloud_1.docx
http://www.paychex.com/a/d/score/top-10-hr-traps-for-small-businesses.docx
http://www.msipc.org/wp-content/uploads/2013/02/C.-diff.-Clean-Differently-2013.docx
http://apps3.eere.energy.gov/greenpower/events/docs/0412_sappi.docx
http://www.msipc.org/wp-content/uploads/2013/02/FIC-Slides-Air_water_waste_2015_VanEnk-21.docx
https://assets.microsoft.com/en-uk/FY15-Lync-Hardware-Partner-Marketing-Playbook_1.docx
http://optimist.org/Documents/Optimist_in_Action_Day.doc
https://www.hud.gov/offices/pih/ih/news/expanding_circle/Documents/Track%202/Integrating%20Culture%20and%20Tradition/Cultural%20O%20Syd%20Beane.doc
http://seadoo-maldives.com/tension.php?lipitor-onset-peak-duration.docx
http://health.usf.edu/NR/rdonlyres/1DC16038-2A42-4ECE-A5E1-7E596579E679/0/QIGME.docx
http://www.womenshealth.gov/heart-truth/heart-truth-docs/Supplemental%20Slide%20Library/HormoneTherapy%20(Supplemental)%20100311.docx
http://teacherweb.com/GA/StarrsMillHighSchool/RobinHuggins/skin-conditions.doc
http://science.kennesaw.edu/%7Emdias/webpage/advanced%20organizers/Tectonics.doc
http://www.onrc.washington.edu/clearinghouse/presentations/acsmtza/acsmtza.DOC
http://ksumsc.com/download_center/4th/Anesthesia/Group%20B/Airway%20evaluation%20and%20management%20%282%29.ppsx
http://www.namica.org/webdocs/conf2014/Villanueva_NAMI%202014presentation.docx
https://assets.microsoft.com/en-us/Managing_Rebates_and_Co-Op_in_CHIP_1.docx
http://home.apu.edu/~ddavis/busi240/chap003_revised.doc
http://api.ning.com/files/lZvpxCE44sVBDaBfn3FvXGV8G97uX2hCzUj3HkPa89m8Mzmj4O8JDzphobEneQSryFQ64C8Tm7U0EBAyfDoD6xwg8csqCE4W/CUEVADEHANGSONDOONG.pps
https://perryhallhs.bcps.org/UserFiles/Servers/Server_4202033/File/Senior%20Assembly%20Graduation%20Info%20DOC.docx
http://www.soc.iastate.edu/sapp/Conflict.doc
http://capital.osd.wednet.edu/media/capital/staff/jansen/ib_chemistry/class_powerpoints/IB_Chemistry._Topic_4._Allotropes_of_Carbon_and_Intermolecular_Forces.docx
http://api.ning.com/files/StXfNzc3V8kX-jhPS4m3I8wsjQrIYsvMpMbvvIw*aEk0X5zBd2sn1CgQEAfZdUOrXe9oPxLbPV115q2JnI-wBnOBqNoih9ZV/Psalms1final2.docx
https://www.eduweb.vic.gov.au/edulibrary/public/postcomp/copperfield_college_presentation.doc
http://www.franklin.kyschools.us/Downloads/Fitness%20Powepoint.doc
http://www.mhhe.com/engcs/compsci/patt/doc/PattPatelCh15.doc
http://www.cres-sn.org/conference/documents/Ensuring_Environmental_Sustainability_for_Africa.docx
http://www.it-servizi.it/template/template_vari/Powerpoint_Templates/Baby%20Blues.pot
http://www.nh-tems.com/documents/C3_HM_Casualty_Care_Course/Burns.doc
http://www.poag.org/wp-content/uploads/2014/05/Command-College-Annual-Class-May-2014-1.docx
http://oregonstate.edu/dept/arotc/E_Book/SMP%20Cadet%20Brief%20Short%20Version.docx
http://www.upenn.edu/computing/group/nptf/archive/2003/sep15/NPTF091503.doc
http://www.afenet.net/downloads/CLWG_OHSI_Orientation.doc
https://www.citrix.com/content/dam/citrix/en_us/documents/reference-material/te602-netscaler-gateway-and-storefront-integration.docx
http://teacherweb.com/VA/PaulVIHighSchool/MrsWhiting/Lesson-5-9--Factoring-Pattern-for-ax2---bx.docx
https://assets.microsoft.com/en-us/Azure_Business_Opportunity_1.docx
http://capital.osd.wednet.edu/media/capital/staff/jansen/chap._16._genetic_engineering_ii_-_ib_stuff_2.doc
https://hilo.hawaii.edu/uhh/faculty/ostertag/documents/HowtoWriteaPersonalStatementintheSciences.doc
http://www.aspcapro.org/sites/pro/files/aspca_new_hire_orientation_template.docx
http://www.msipc.org/wp-content/uploads/2013/02/Infection-control-in-CKD.docx
http://www.aoifeonline.com/uplds/Campbell.doc
http://teacherweb.com/NF/HolyTrinityHigh/AChislett/Chapter_6_First_World_War_part-2.doc
http://www.beg.utexas.edu/cswr/aquiferstudy/files/012810%20CW%20Stakeholder%20Presentation.docx
http://hilo.hawaii.edu/uhh/faculty/furumo/documents/ch5final.doc
https://assets.microsoft.com/en-us/WindowsIntune-Open-Launch_1.docx
https://www.msudenver.edu/media/content/electricalengrtech/EET%20Flowchart.docx
http://www.ceeindia.org/cee/project_pages/presentations/watsan.pps
http://hilo.hawaii.edu/uhh/faculty/furumo/documents/chapter2.doc
http://olympia.osd.wednet.edu/media/olympia/departments/english/mcdougall/israel/israeli_wars.doc
http://merlinhawkaerospace.com/images/AMPEX.doc
http://web-01.canyons.edu/Faculty/naddafpoura/Bus110/Bus110Ch07-PPP.doc
http://srcsnelson.weebly.com/uploads/2/6/0/2/26022412/chapter_12__an_age_of_darkness__-_part_ii.docx
http://www.aemma.org/misc/muscle-elasticity.doc
http://ggim.un.org/docs/UN%20Initiative%20on%20GGIM.doc
http://cdichtel.net/column.php?synthroid-lowest-dose.docx
http://www.mcsr.olemiss.edu/mathematica/fall_sem/CSeminar.doc
http://www1.telemessage.com/upload/infocenter/info_images/23052011144027@APM%20Technical%20Training%20-%20Part%203%20-%20Communication%2013042011.docx
http://olympia.osd.wednet.edu/media/pagefiles/126.find_your_future_-_aligning_interests_and_attributes_to_a_career.docx
http://www3.canyons.edu/Faculty/rosalesr/202/Lectures/Chapter4.doc
http://www.ismsd.org/library/ISM_TCO_presentation1-17-12.docx
http://www.tdi.texas.gov/fire/documents/fmhomesafety.doc
http://www.vanderbilt.edu/AnS/religious_studies/210/august22.ppsm
http://www.grainchain.com/Resources/11-14/Seasonal/Flour-types.doc
http://www.efcoc.org/doc/20170108M_choir.doc
https://michigan.gov/documents/deq/deq-ess-p2-dod-slideshow_274976_7.doc
http://labstat.psa.gov.ph/learnstat/trends%20and%20patterns_V.5_052414.doc
http://capital.osd.wednet.edu/media/capital/staff/jansen/chap._11._genes_on_chromosomes.doc
http://www.studenthealthassociation.co.uk/conferences/2014/10%20years%20in%20the%20life%20of%20a%20nurse%20prescriber%20at%20SHS.docx
http://www.puurveltman.nl/neurontin-generic-name-gabapentin.docx
http://www.extension.iastate.edu/feci/annie/TrueColors.doc
http://www.p12.nysed.gov/biling/bilinged/documents/PPMeeting5-15-06.doc
http://www.atloaug.org/presentations/Aug01Ernesto.doc
https://www.uscg.mil/hq/cg5/TVNCOE/Documents/Presentations/UTVCourse/CredentialsWatchstanding.docx
https://agnewatess.eq.edu.au/Supportandresources/Formsanddocuments/Documents/PARENT%20INFORMATION%20NIGHT%202015.ppsx
http://webapp.browardschools.com/esstorage/3151-181/presentation/3151TequestaTraceMiddle_AshleyWater%20pollution.doc
http://capital.osd.wednet.edu/media/capital/staff/jansen/ib_chemistry/class_powerpoints/Topic_4.3._Network_macro_Covalent_Bonding.docx
http://olympia.osd.wednet.edu/media/olympia/departments/science/smith/biochem/carbon_compounds.doc
https://www.nd.gov/espb/TeacherSupport/Mentoring/MentorTraining%20PowerPoint.docx
http://www.schsl.org/2013/pp2014SBweb.pps
https://www.iata.org/whatwedo/Documents/ICH/SIS%20P3%20-%20RA43%20-%20Introduction%20to%20SIS.doc
http://www.med.navy.mil/dha_dhits/NavyDaysMurderboard%20Document%20Library/ND11_Governance%20Primer%202010-12-21.docx
http://plantationgeneral.com/util/documents/Surviving_Sepsis.docx
http://www-hep.physics.uiowa.edu/~vincent/courses/29273/TensorPrimer.doc
http://www.centerforspace.com/downloads/files/pubs/AAS-05-200.doc
http://capital.osd.wednet.edu/media/capital/staff/mcfadden/law_and_justice/course_outline/c18/street_law.unit_3.ch._18.torts.a_civil_wrong.docx
http://css.insttech.washington.edu/~lab/BasicSkills/AdminXPBasic.doc
http://capital.osd.wednet.edu/media/capital/staff/vandiver/JFK_Assassination.doc
http://web43.canyons.edu/Faculty/naddafpoura/Bus110/Bus110Ch10-PPP.doc
http://www.ida.net/users/rrobbins/MarkTwain.docx
https://assets.microsoft.com/en-us/customer_briefing_how_to_count_deployments_and_license_assignments.docx
http://grtc.ucsd.edu/old_essentials/2004/lecture20.pps
http://bbaworldwide.com/wp-content/uploads/2013/12/Chapter-4-Managing-Marketing-Information-to-Gain-Customer-Insights.docx
http://www.uneca-an.org/rd/presentations/Shideed%20ICARDA.doc
http://www.urhcs.org/res/files/1016/Global_Tracheostomy_Collaborative_Up-Date.docx
http://chemistry.montana.edu/~martint/BCHM444/Radioimmunoassay.doc
http://www3.canyons.edu/faculty/wonserr/Social%20Problems/Lectures/Social%20Problems%20-%20Frames%20and%20Claimsmaking.doc
http://hilo.hawaii.edu/uhh/faculty/furumo/documents/Chapter6_000.doc
http://www.coe.montana.edu/jeffrey.heys/web451/lecture1.docx
http://gaumers.com/management.php?is-abilify-a-major-tranquilizer.docx
http://cedt.iisc.ernet.in/people/kuri/Comsnets/Presentations/Unlocking-Parul.doc
http://ner6-bsa.org/wp/wp-content/uploads/2014/11/2014-Area-6-NE-Fall-Conference.docx
http://capital.osd.wednet.edu/media/capital/staff/jansen/02_chemistry/Chapter_16_notes._Molarity.doc
http://www.socalcfc.org/files/cfc_online_pledging.doc
http://www.niv-zmora.com/lectures/radiology/%F9%E9%F2%E5%F8%20%EE%F1'%204%20-%20%E3%E9%EE%E5%FA%20%E4%E7%E5%EC%E4%20%E1%F6%E4%E1%FA%205.11.07.doc
http://www.encotech.com/docs/Steam_Path_Audit_Presentation.doc
http://www.ut.edu.sa/documents/10156/2890319/lecture+1
http://www.teacherweb.com/CA/NewburyParkHighSchool/MsWhiteman/Pride-and-Prejudice-by-Jane-Austen.doc
http://www.ils.unc.edu/%7Ejpom/conf/JCDL_2007_Workshop-old.doc
http://www.gonuke.org/acad/Dose%20Equivalent.docx
http://defensecommunities.org/wp-content/uploads/2012/01/ADC-2013-IIF-RB-Eidson-Presentation-15-Jan-20131.docx
https://www.psusd.us/sites/default/files/Budget%20%20Presentation%20for%202015-2016%20-%20060915.docx
http://www.bcasbapatla.ac.in/material/Database%20management%20system.doc
http://www.eaganhs.portal.rschooltoday.com/page/6557/downloadFile/13197
http://capital.osd.wednet.edu/media/capital/staff/jansen/chap__1_notes___science_and_chemistry_2009.docx
http://www.myanmarwebdesigner.asia/how-buy-clavamox-online-without-prescription-overnight-rx.docx
http://home.apu.edu/~jbirch/BUSI240/Do%e2%80%99s%20and%20Don%e2%80%99ts%20of%20PowerPoint%20Presentations%20Rev%202.doc
http://www.parm-radiology.org/2011_PARM_AUTUMN_SYMPOSIUM_vendor_slide_show.docx
http://aluminium-dubai.com/RX/Aluminium%20ME%202013%20Speakers%20Presentation/1st%20Day/PROJESYS%20INTERNATIONAL/Presentation-Commissioning-Aluminium%20MEA%202013%20rev1.docx
http://www.franklin.kyschools.us/Downloads/Transformations%20on%20the%20Coordinate%20Plane.docx
http://capital.osd.wednet.edu/media/capital/staff/mcfadden/personal_finance/course_outline/vbpf/vb.pf.l6.shopping.docx
http://hilo.hawaii.edu/uhh/faculty/furumo/documents/ch5.doc
http://home.apu.edu/~ddavis/busi240/chap009.doc
http://capital.osd.wednet.edu/media/capital/staff/mcfadden/entrepreneurship/course_outline/whatsyouriq/1.assessing_your_social_intelligence.docx
http://seadoo-maldives.com/whisper.php?singulair-4-mg-30-comprimidos.docx
http://teacherweb.com/VA/PaulVIHighSchool/MrsWhiting/Lesson-3-7-Graphs-of-Rational-Functions-student-version.docx
http://capital.osd.wednet.edu/media/capital/staff/mcfadden/law_and_justice/co/c31/street_law.unit_5.ch._31.marriage.original.docx
http://olympia.osd.wednet.edu/media/olympia/departments/science/shelton/knee.doc
http://health.usf.edu/NR/rdonlyres/DADC955E-1220-4E96-9F17-91A51535E0EB/0/QualityAssurancePresentationSASBMarch15.docx
http://capital.osd.wednet.edu/media/capital/staff/jansen/ib_chemistry/class_powerpoints/Topic_B.7_Enzymes2014.doc
http://capital.osd.wednet.edu/media/capital/staff/jansen/chap._5_notes._electrons_part_iii_electron_configuration_1.3.doc
http://www3.canyons.edu/faculty/wonserr/Deviance/Lecture%209%20-%20Ch%2015
http://www.lisarow-p.schools.nsw.edu.au/documents/6943225/6949398/Coral%20Festival%20and%20Percussion%20Group.docx
http://capital.osd.wednet.edu/media/capital/staff/machut/Chapter_17._Magnetism._CPO.docx
http://www.brandeis.edu/hiatt/facultystaffcol/minds/WOW.doc.docx
http://www.bsj.org.jm/Portals/0/ncbj/NCBJ_Customer%20Care%20Presentation_Nov_10_2011.doc
http://washington.osd.wednet.edu/media/washington/staff/burroughs_candyce/robotics/tribot_gears_xclent.doc
http://www.emseducation.info/uploads/Pediatric_Assessment_Format.doc
http://www.tricare.mil/ocfo/_docs/T-2-1300_Case_Management.doc
http://capital.osd.wednet.edu/media/capital/staff/jansen/chap._10_notes._empericla_and_molecular.doc
http://olympia.osd.wednet.edu/media/olympia/departments/science/stevick/physical_science/practice_problems_work_and_mechanical_advantage.doc
http://miamiurbanleague.org/wp-content/uploads/2010/07/UL-Report_Card.doc
https://static-content.springer.com/esm/chp%3A10.1007/978-3-319-43577-0_1/MediaObjects/328040_1_En_1_MOESM1_ESM.docx
https://www.psusd.us/sites/default/files/Business_Services_PSUSD%20Governor's%20Budget%20Update%202.28.13.docx
https://plantationgeneral.com/util/documents/Congestive_Heart_Failure_Dr_Jancko.docx
http://www.mdmunicipal.org/DocumentCenter/View/1402
http://courses.softlab.ntua.gr/softeng/Tutorials/Reliability.doc
http://methacton.org/cms/lib/PA01000176/Centricity/Domain/121/Day%202%20-%20Intro%20to%20psychology.docx
https://webapp.browardschools.com/esstorage/0452-235/presentation/0011_Whiddon-Rogers_EnergyPlan.doc
http://nhsrcindia.org/biodata/An%20experience%20in%20operationalising%20Integrated%20Occupational%20Health%20Service%20in%20Indian%20Railways.docx
https://www.andrews.edu/leaderpart/RoundTable/2004/joust4/15/The_Role_of_Higher_Education_in_the_Formation_DOC.doc
http://dpi.wi.gov/sites/default/files/imce/school-nutrition/doc/verif_what.doc
http://www.warrencountyschools.org/userfiles/2546/Classes/79796/chsix.doc
http://www.uwgb.edu/embi/files/doc/kramer.doc
http://www.oulfc.co.uk/assets/Academy-images/Resources/unit-7-p1-m1.docx
http://www.w5online.co.uk/fs/doc/EducResource/nanotechnology/Snakes%20and%20ladders%20rules.doc
http://www.ecaa.ee/public/Part-M_Continuing_Airworthiness.docx
http://spacegrant.arizona.edu/sites/spacegrant.arizona.edu/files/documents/opportunities/symposium/2014/presentations/Session%20A%20-%20ASCEND/[A-20]%20Morris
http://hypercoils.com/DOC/Hyperco_Carbon-Composite.doc?gsleadDesc=Product+Presentation
http://www.goes-r.gov/downloads/GOES-R_Series_Program/2015/GOES-R_BrownBag_20150701_Kuligowski.docx
http://capital.osd.wednet.edu/media/capital/staff/jansen/chap._27_notes._class_mammalia.doc
http://olympia.osd.wednet.edu/media/olympia//departments/science/smith/bioethics/bioethics_lesson_8.doc
http://www.brandeis.edu/hiatt//facultystaffcol/minds/WOW.doc.docx
http://www.lmhpco.org/blahdocs/uploads/medpac_11december2009_2116.doc
http://hazwastemanagement.info/Powerpoint/chapter8.doc
http://www.acepidemiology.org/meetings/2007Miami/documents/HPV_Policy_9_17_07.doc
http://www.upenn.edu/computing/group/nptf/archive/2009/may04/may04nptf.doc
https://www.tdi.state.tx.us/fire/documents/fmclasssafe.doc
http://home.apu.edu/~jsimons/Bio101/noahsark.DOC
http://health.usf.edu/NR/rdonlyres/7E3BED8B-D667-42C9-8840-1FF00D604974/0/ConflictofInterestBioEthicsClass020607II.doc
http://www.srhsfalcons.org/ourpages/auto/2015/9/8/47271854/MODIFIERS%20notes%20and%20exercises.docx
https://ncar.ucar.edu/sites/default/files/NCARDayBio_Brown_Potts.doc
http://watecsolutions.com/wp-content/uploads/2014/10/Accounting-Training.docx
http://www.brgs.me/departments/schemes/year12/history/1947-turningpointforlabour.doc
http://engineering.uprm.edu/inme/vgoyal/inme3810/Online_inme3810/NXTutorials/UGS_NX_Tutorial_1.docx






share|improve this question














I would like to insert URL's in banned_url_lists.txt text file into mysql database table called 'banned_url_links' There is also different characters in URL's e.g.(" ' " and " ") all urls should be inserting to mysql as it is.
I would like this script to check duplicate URL's in mysql column name 'links' and insert only unique ones (banned_url_links.txt text file is removed and and creating new links everyday, therefore duplicate checks has to be against mysql table not on text file). I want also inserting date for each records (I already done on mysql side but I am not sure it will work without sending date to mysql). My database structure, banned_url_lists.txt and bash script are below.



MYSQL table structure



Table (banned_url_links) structure

1 ID int(10) No None AUTO_INCREMENT
2 date timestamp No CURRENT_TIMESTAMP
3 links varchar(300) utf8_general_ci No None


My bash script



#!/bin/bash

host="1.1.1.1";
DBName='wpmy_db';
DBUser='wp_myuser';
DBPass='137T321uS&*3j5';
File=banned_url_list.txt;
MYSQL="mysql -u$ DBUser -p$ $DBName DBPass -h $host";
echo $MYSQL;

$MYSQL -e "INSERT INTO banned_url_links SET links = $File";
$MYSQL LOAD DATA INFILE 'banned_url_list.txt' INTO TABLE wpmy_db.links;
EOF


banned_url_links.txt



http://www.tricare.mil/ocfo/_docs/2011_R-5-1000%20_%20CPT%20Coding%20for%20Cardiac_Redacted.doc
http://www.berachahbiblechurch.org/assets4---exodus.doc
http://teacherweb.com/GA/Keheleyelementary/Johnson/MultipleMeaning.doc
http://teacherweb.com/VA/PaulVIHighSchool/MrsWhiting/8-2Heron.doc
http://www.fresnocitycollege.edu/Modules/ShowDocument.aspx?documentid=2277
http://www.mae.ncsu.edu/academics/truss-app/2014MathWorksPresentation.docx
http://teacherweb.com/VA/PaulVIHighSchool/MrsWhiting/Lesson-4-6-Rational-Equations-and-Partial-Fractions.docx
http://www.coffschurch.org.au/images/EPHESIANS%20FOR%20TODAY'S%20CHURCH.ppsx
http://www.asphn.org/resource_files/339/339_resource_file1.doc
http://www.rucharacter.org/file/Lesson1v2FINAL(1).pps
http://web.cs.sunyit.edu/~sengupta/cs330/MOS3e_ch7_97.docx
http://origin.library.constantcontact.com/download/get/file/1101686237960-61/Dont+Forget+about+Prolotherapy+LAOM+0913.docx
http://www.it-servizi.it/template/template_vari/Powerpoint_Templates/America%20the%20Beautiful.pot
https://royalmechanical.files.wordpress.com/2011/06/failure-of-rolling-contact-bearings.doc
http://capital.osd.wednet.edu/media/capital/staff/jansen/02_chemistry/Gen_Chemi_2016_The_Periodic_Table_final_one_docx.docx
http://washington.osd.wednet.edu/media/washington/staff/burroughs_candyce/energy/forms_nrg.doc
http://www.ccaeagles.org/file/GoToCollegeWithoutGoingBrokePowerPoint.doc
http://natres.psu.ac.th/Animal/disease_USA/Chicken%20dis/Leucosis%20MD.doc
https://research.wustl.edu/ComplianceAreas/ExportControls/Documents/ExportControls_RAForum_July2014.docx
http://champion-container.com/inside.php?zithromax-single-dose-gonorrhea.docx
http://gauntletpress.com/mix.php?how-much-allegra-to-get-high.docx
https://www.uscg.mil/hq/cg5/TVNCOE/Documents/Presentations/UTVCourse/SeattlePortland.docx
http://scisweb.ulster.ac.uk/~kevin/com535/slides/7%20Public%20Key%20Cryptography%20%26%20Message%20Authentication.docx
http://www.bsj.org.jm/Portals/0/ncbj/C_White%20Quality%20Management_A%20Financial%20Perspective%5B1%5D.doc
http://web43.canyons.edu/Faculty/naddafpoura/Bus110/Bus110-PrincOfMgmt-Ch01-PPP.doc
http://www.rhpc.us/go/doc/4207/1226799/3M-FR-57-Gas-Filter-Cartridge-docx
http://hr.southtexascollege.edu/forms/misc/2013-2014%20PERFORMANCE%20APPRAISAL.doc
http://ntp.neuroscience.wisc.edu/resource/cid/files/UW-Mad%20Ideas.doc
http://teacherweb.com/VA/PaulVIHighSchool/MrsWhiting/Lesson-4-5-Fundamental-Theorem-of-Algebra.docx
http://www.cse.wustl.edu/~vgruev/cse/260/lecture_slides/chapter9.docx
http://www.academic.luzerne.edu/jpisano/Copy%20of%2006%20Thinking
http://api.ning.com/files/a6fJNn6lELJMxMrXBKLma1d0EfZbYFfy-39lKasULAVvoAqP22qpFALQBU0ipoPtWZFPoPB2Imw9Gfo2U6TNrHdQETKhkgBm/CISCOFINAL.docx
http://fdin.org.uk/output/Packaging%2012/Cold%20Press%20Case%20Study.pps
http://www.midamerica.imanet.org/Web_Files/Sales_Tax_Streamlining.docx
http://www.ireeindia.org/iree/Firth-Whitwam.doc
http://www.mgdservices.com/QA.doc
http://www.msipc.org/wp-content/uploads/2013/02/Evaluation-of-UV-Light-Technology-and-CDI_Alison-Gibson-12.docx
http://wood-ridgeschools.org/cms/lib6/NJ01001835/Centricity/Domain/471/AchieveNJ%20SGO%202%200%20-%20from%20Compliance%20to%20Quality.docx
http://capital.osd.wednet.edu/media/capital/staff/machut/newtons_laws_of_motion-Machut.doc
https://assets.microsoft.com/en-us/apex_sellerguidance_1.docx
http://www.franklin.kyschools.us/Downloads/Body%20Composition%20Day%2015%202014.docx
http://www.pmr.vcu.edu/presentations/pps/PedMusculoskeletal.pps
http://www.renal.org/docs/default-source/clinical-service/clinical-service/CAB_Report_-_Dr_Kevin_Harris.doc?sfvrsn=0
https://assets.microsoft.com/en-us/Lync-Server-2010---Pricing-and-Licensing-Guide-for-Partners_1.docx
http://capital.osd.wednet.edu/media/capital/staff/samson/WizardofOz.doc
http://capital.osd.wednet.edu/media/capital/staff/jansen/chap._10_notes._v__a.doc
http://puurveltman.nl/best-antibiotic-for-sinus-infection-bactrim.docx
https://assets.microsoft.com/en-us/Enterprise-Cloud-Suite-customer-deck-for-partners_1.docx
http://home.apu.edu/~ksetterlund/2011-2012/FY%20Field%20Orientation%202011.doc
http://www.dataminingbook.com/system/files/Chap5_MultipleLinearRegression_0.doc
http://teacherweb.com/MA/LexingtonPublicSchools/highschoolbehs/aphgcore-areas2.doc
http://courses.softlab.ntua.gr/softeng/Tutorials/TutorialUML.doc
http://www3.canyons.edu/Faculty/rosalesr/202/Lectures/Chapter7.doc
http://capital.osd.wednet.edu/media/capital/staff/mcfadden/espresso_operations/co/vbr/vbr.l15.financial_statements.docx
http://rkala.in/download/From%20source%20to%20software.doc
http://www.shsu.edu/~agr_www/documents/U10L4.doc
http://www.up.edu/showimage/show.aspx?file=22142
http://www.sabresocials.com/jacquie/Geography%2012/Grade%2012%20Presenations/OZONE_DEPLETION2.doc
http://www.michigan.gov/documents/mde/Afterschool_Snack_Program_Training_Module_508679_7.docx
http://apps3.eere.energy.gov/greenpower/conference/4gpmc99/tutt.doc
http://www.lstechllc.com/beta/wp-content/uploads/2012/05/LST-Corporate-Briefing_2016-04-131.docx
http://education.ky.gov/teachers/pges/spges/documents/spges%20for%20training%20doc.docx
http://www.ucilmsa.org/The%20mexican%20health%20care%20system%20(Rios).doc
http://gauntletpress.com/volume.php?synthroid-generic-vs-brand-name.docx
http://puurveltman.nl/flagyl-200-mg-suspension.docx
https://www.nbb.be/doc/ts/products/paymentsystems/sepa/sepa_dd_mob_20100322.doc
http://www.franklin.kyschools.us/Downloads/Substitution%20Real%20World%20Problems.docx
http://garthmoon.com/static/imagesOpus/140613-1-vietnam-reference-file/Vietnam-Victoria-Healthcare/110613-Competitive-Analysis.docx
http://home.apu.edu/~ddavis/docpres/organizational_notes.doc
http://www.sabresocials.com/kevin/Programming11to12.doc
http://scisweb.ulster.ac.uk/~kevin/com320/slides/Chapter9-OperatingSystems.docx
http://www.markpatent.org/19thapril07/presentation/michel.DOC
http://teacherweb.com/GA/StarrsMillHighSchool/RobinHuggins/burns-powerpoint-2.doc
http://www.ccgcd.org/Education/Water%20Conservation%20DOC%20Draft%202.docx
http://www.jeffcoeoc.org/documents/MyStateUSA.docx
http://www.msipc.org/wp-content/uploads/2013/02/FIC-Slides-OccupationalHealth_2015.docx
http://www.lancastershrm.org/handouts/HRTechnology2.ppsx
http://capital.osd.wednet.edu/media/capital/staff/jansen/ib_chemistry/class_powerpoints/Topic_4.1_IB_Chem_Ionic_Bonding.doc
https://www.ut.edu.sa/documents/10156/2890319/lecture+2
http://grtc.ucsd.edu/old_essentials/2004/lecture5.pps
http://capital.osd.wednet.edu/media/capital/staff/jansen/ib_chemistry/class_powerpoints/Topic_1.1._States_of_Matter_docx.docx
http://www.dese.iisc.ernet.in/people/kgopa/CEDT_part1.doc
http://capital.osd.wednet.edu/media/capital/staff/finley/the_metric_system.doc
http://www.cmu.edu/finance/budget/overview/files/budget_theory_presentation.doc
http://mmbgims.com/docs/doc/3.ppsx
http://www.bath.kyschools.us/userfiles/64/Classes/4661/Guitar%20Unit%201-0.docx
http://cdn.metroparent.com/wp-content/uploads/Acting-Out-–-Simple-Ways-to-Improve-Your-Childs-Problem-Behavior.docx
https://www.quia.com/files/quia/users/jaratermann/__GV2016/Week8-perfect_tenses_rvsd3.docx
http://www.uta.edu/faculty/david/SAIR_2008.pps
http://www.cres-sn.org/conference/documents/Artificial_insemination_productivity_and_growth.docx
http://userpages.umbc.edu/~jc4/orals.doc
http://www.uvm.edu/rsenr/wfb279/presentations/Phytoplankton_Dynamics.doc
http://advising.uncc.edu/sites/advising.uncc.edu/files/media/Importance-of-Developmental-Advising-Especially-with-First-Generation-Students.docx
http://gravytrainpoutinerie.com/accident.php?otc-antibiotics.docx
http://www.midwestenergy.org/uploads/2/6/8/3/26833428/natgasbootcamp2014.docx
http://www.franklin.kyschools.us/Downloads/Informational%20Writing%20DOC.docx
http://capital.osd.wednet.edu/media/capital/staff/jansen/ib_chemistry/class_powerpoints/Topic_1.1._States_of_Matter_2017_docx.docx
http://www.breakingthemould.co.uk/files/Selby/TURKEY.pps
http://comsci.liu.edu/~jrodriguez/cs645sp10/chapter5.doc
http://www.the-hpo.com/downloads/Effective%20Business%20%20Process%20Mapping%20V10.doc
http://www.thekingsschoolwr.co.za/Tabdata/Grade%209/THINGS%20FALL%20APART%20new.docx
http://www.acjrca.org/doc08/11-%20HardenPandemic.doc
http://www.heartofthemidlandscfc.org/files/TheBigPicture6October2015.docx
http://www.studenthealthassociation.co.uk/conferences/2014/SHA_Travel_Presentation.doc
http://www.studiolegalesilvestrini.it/Presentazione_Avv_Silvestrini_3.doc
http://teacherweb.com/LA/RiversideElementarySchool-Shreveport/MrsSimmons/mayaaztecandinca1.doc
http://www.msipc.org/wp-content/uploads/2013/02/FIC-Slides-NrsgHomePneumonia_2015-.doc
http://web-01.canyons.edu/Faculty/naddafpoura/Bus100/Bus100Ch04PPP.doc
http://www.sabresocials.com/jacquie/Geography%2012/Grade%2012%20Presenations/Hydro-Wind%20Power2%20curtis%20leblanc.doc
http://nadp.sws.uiuc.edu/cladws/doc/galloway.doc
http://ucblibraries.colorado.edu/govpubs/conference/handouts/emetrics.doc
http://capital.osd.wednet.edu/media/capital/staff/jansen/chap.27notes.chordata_web.doc
http://www.goes-r.gov/downloads/GOES-R_Series_Program/2014/10-Anderson_pres.docx
http://www.avon.nhs.uk/phnet/Avonsafe/Falls-ResCare/Medicines%20and%20Falls.doc
http://www.soc.iastate.edu/Sapp/Feminist.doc
http://statler.wvu.edu/freshman/fya/StaA.docx
http://www.warrencountyschools.org/userfiles/2719/Classes/7849/01%20Endocrine%20and%20Cell%20Communication%20%20Introduction.docx
http://www.healthnettpo.org/files/716/qualitative-research-on-the-psychosocial-impact-of-war-on-children-in-burundi-and-indonesia-it-never-rains-it-pours.doc
http://teacherweb.com/LA/NorthshoreHighSchool/Guidance/TOPS--FAFSA-ETC-2015-Grads-AUG-2014-30-min.docx
https://assets.microsoft.com/en-us/Office-365-Ignite-BPOS-to-Office-365-Transition_1.docx
http://www2.sunysuffolk.edu/anastaj/OC%2015%20web%20page/Lectures/Powerpoint/Nekton%20F06.doc
http://faculty.mercer.edu/salido_t/BME426/Cardiac%20MRI.doc
http://www.ee.sc.edu/classes/Fall11/elct774/Class_Notes/ELCT_774_Lecture_19.doc
http://www.ce.washington.edu/~palmer/classes/CEE576/Lectures/Intro/Intro.doc
http://nsttac.org/sites/default/files/assets/doc/DoingtheRightThinginClintonArkansas.doc
http://download.microsoft.com/download/4/d/1/4d100840-8114-4716-9a05-f8632f56e6c1/UNC452-Schnoll.docx
http://www.omega6d.org/~omega6d/sites/default/files/Sixth_District_Undergraduate_Leadership_Summit_rev_7.ppsx
http://teacherweb.com/MA/LexingtonPublicSchools/highschoolbehs/AP-Green-Revolution1.doc
http://www.armasouthwest.org/crm_conferences/2016crm/materials/Adv.%20Track%206_Challenges%20of%20Information%20Governance.docx
http://www.nebraskamed.com/app_files/doc/sota/implementingrelationshipbasedcare.docx
http://grid.cs.gsu.edu/~cscbecx/Class%20Slides/CSCI%203360%20Database%20Systems/Chapter%202.doc
http://lms.abuad.edu.ng/claroline/backends/download.php?url=L0dTVF8xMTNfcHA1LnBwdHg%3D&cidReset=true&cidReq=GST113_002
http://mrjoycemtsinai.weebly.com/uploads/1/8/1/7/18175567/light_and_waves.docx
http://webapp.browardschools.com/esstorage/3221-35/presentation/CRDGoGreen.pps
http://capital.osd.wednet.edu/media/capital/staff/jansen/chap._6_notes._periodic_table.doc
http://teacherweb.com/LA/FontainebleauHighSchool/ChristyCMayfield/The-Final-Solution-7th-hour2.docx
https://assets.microsoft.com/en-us/Microsoft-Licensing-Options-for-Partner-Hosted-Cloud_1.docx
http://www.paychex.com/a/d/score/top-10-hr-traps-for-small-businesses.docx
http://www.msipc.org/wp-content/uploads/2013/02/C.-diff.-Clean-Differently-2013.docx
http://apps3.eere.energy.gov/greenpower/events/docs/0412_sappi.docx
http://www.msipc.org/wp-content/uploads/2013/02/FIC-Slides-Air_water_waste_2015_VanEnk-21.docx
https://assets.microsoft.com/en-uk/FY15-Lync-Hardware-Partner-Marketing-Playbook_1.docx
http://optimist.org/Documents/Optimist_in_Action_Day.doc
https://www.hud.gov/offices/pih/ih/news/expanding_circle/Documents/Track%202/Integrating%20Culture%20and%20Tradition/Cultural%20O%20Syd%20Beane.doc
http://seadoo-maldives.com/tension.php?lipitor-onset-peak-duration.docx
http://health.usf.edu/NR/rdonlyres/1DC16038-2A42-4ECE-A5E1-7E596579E679/0/QIGME.docx
http://www.womenshealth.gov/heart-truth/heart-truth-docs/Supplemental%20Slide%20Library/HormoneTherapy%20(Supplemental)%20100311.docx
http://teacherweb.com/GA/StarrsMillHighSchool/RobinHuggins/skin-conditions.doc
http://science.kennesaw.edu/%7Emdias/webpage/advanced%20organizers/Tectonics.doc
http://www.onrc.washington.edu/clearinghouse/presentations/acsmtza/acsmtza.DOC
http://ksumsc.com/download_center/4th/Anesthesia/Group%20B/Airway%20evaluation%20and%20management%20%282%29.ppsx
http://www.namica.org/webdocs/conf2014/Villanueva_NAMI%202014presentation.docx
https://assets.microsoft.com/en-us/Managing_Rebates_and_Co-Op_in_CHIP_1.docx
http://home.apu.edu/~ddavis/busi240/chap003_revised.doc
http://api.ning.com/files/lZvpxCE44sVBDaBfn3FvXGV8G97uX2hCzUj3HkPa89m8Mzmj4O8JDzphobEneQSryFQ64C8Tm7U0EBAyfDoD6xwg8csqCE4W/CUEVADEHANGSONDOONG.pps
https://perryhallhs.bcps.org/UserFiles/Servers/Server_4202033/File/Senior%20Assembly%20Graduation%20Info%20DOC.docx
http://www.soc.iastate.edu/sapp/Conflict.doc
http://capital.osd.wednet.edu/media/capital/staff/jansen/ib_chemistry/class_powerpoints/IB_Chemistry._Topic_4._Allotropes_of_Carbon_and_Intermolecular_Forces.docx
http://api.ning.com/files/StXfNzc3V8kX-jhPS4m3I8wsjQrIYsvMpMbvvIw*aEk0X5zBd2sn1CgQEAfZdUOrXe9oPxLbPV115q2JnI-wBnOBqNoih9ZV/Psalms1final2.docx
https://www.eduweb.vic.gov.au/edulibrary/public/postcomp/copperfield_college_presentation.doc
http://www.franklin.kyschools.us/Downloads/Fitness%20Powepoint.doc
http://www.mhhe.com/engcs/compsci/patt/doc/PattPatelCh15.doc
http://www.cres-sn.org/conference/documents/Ensuring_Environmental_Sustainability_for_Africa.docx
http://www.it-servizi.it/template/template_vari/Powerpoint_Templates/Baby%20Blues.pot
http://www.nh-tems.com/documents/C3_HM_Casualty_Care_Course/Burns.doc
http://www.poag.org/wp-content/uploads/2014/05/Command-College-Annual-Class-May-2014-1.docx
http://oregonstate.edu/dept/arotc/E_Book/SMP%20Cadet%20Brief%20Short%20Version.docx
http://www.upenn.edu/computing/group/nptf/archive/2003/sep15/NPTF091503.doc
http://www.afenet.net/downloads/CLWG_OHSI_Orientation.doc
https://www.citrix.com/content/dam/citrix/en_us/documents/reference-material/te602-netscaler-gateway-and-storefront-integration.docx
http://teacherweb.com/VA/PaulVIHighSchool/MrsWhiting/Lesson-5-9--Factoring-Pattern-for-ax2---bx.docx
https://assets.microsoft.com/en-us/Azure_Business_Opportunity_1.docx
http://capital.osd.wednet.edu/media/capital/staff/jansen/chap._16._genetic_engineering_ii_-_ib_stuff_2.doc
https://hilo.hawaii.edu/uhh/faculty/ostertag/documents/HowtoWriteaPersonalStatementintheSciences.doc
http://www.aspcapro.org/sites/pro/files/aspca_new_hire_orientation_template.docx
http://www.msipc.org/wp-content/uploads/2013/02/Infection-control-in-CKD.docx
http://www.aoifeonline.com/uplds/Campbell.doc
http://teacherweb.com/NF/HolyTrinityHigh/AChislett/Chapter_6_First_World_War_part-2.doc
http://www.beg.utexas.edu/cswr/aquiferstudy/files/012810%20CW%20Stakeholder%20Presentation.docx
http://hilo.hawaii.edu/uhh/faculty/furumo/documents/ch5final.doc
https://assets.microsoft.com/en-us/WindowsIntune-Open-Launch_1.docx
https://www.msudenver.edu/media/content/electricalengrtech/EET%20Flowchart.docx
http://www.ceeindia.org/cee/project_pages/presentations/watsan.pps
http://hilo.hawaii.edu/uhh/faculty/furumo/documents/chapter2.doc
http://olympia.osd.wednet.edu/media/olympia/departments/english/mcdougall/israel/israeli_wars.doc
http://merlinhawkaerospace.com/images/AMPEX.doc
http://web-01.canyons.edu/Faculty/naddafpoura/Bus110/Bus110Ch07-PPP.doc
http://srcsnelson.weebly.com/uploads/2/6/0/2/26022412/chapter_12__an_age_of_darkness__-_part_ii.docx
http://www.aemma.org/misc/muscle-elasticity.doc
http://ggim.un.org/docs/UN%20Initiative%20on%20GGIM.doc
http://cdichtel.net/column.php?synthroid-lowest-dose.docx
http://www.mcsr.olemiss.edu/mathematica/fall_sem/CSeminar.doc
http://www1.telemessage.com/upload/infocenter/info_images/23052011144027@APM%20Technical%20Training%20-%20Part%203%20-%20Communication%2013042011.docx
http://olympia.osd.wednet.edu/media/pagefiles/126.find_your_future_-_aligning_interests_and_attributes_to_a_career.docx
http://www3.canyons.edu/Faculty/rosalesr/202/Lectures/Chapter4.doc
http://www.ismsd.org/library/ISM_TCO_presentation1-17-12.docx
http://www.tdi.texas.gov/fire/documents/fmhomesafety.doc
http://www.vanderbilt.edu/AnS/religious_studies/210/august22.ppsm
http://www.grainchain.com/Resources/11-14/Seasonal/Flour-types.doc
http://www.efcoc.org/doc/20170108M_choir.doc
https://michigan.gov/documents/deq/deq-ess-p2-dod-slideshow_274976_7.doc
http://labstat.psa.gov.ph/learnstat/trends%20and%20patterns_V.5_052414.doc
http://capital.osd.wednet.edu/media/capital/staff/jansen/chap._11._genes_on_chromosomes.doc
http://www.studenthealthassociation.co.uk/conferences/2014/10%20years%20in%20the%20life%20of%20a%20nurse%20prescriber%20at%20SHS.docx
http://www.puurveltman.nl/neurontin-generic-name-gabapentin.docx
http://www.extension.iastate.edu/feci/annie/TrueColors.doc
http://www.p12.nysed.gov/biling/bilinged/documents/PPMeeting5-15-06.doc
http://www.atloaug.org/presentations/Aug01Ernesto.doc
https://www.uscg.mil/hq/cg5/TVNCOE/Documents/Presentations/UTVCourse/CredentialsWatchstanding.docx
https://agnewatess.eq.edu.au/Supportandresources/Formsanddocuments/Documents/PARENT%20INFORMATION%20NIGHT%202015.ppsx
http://webapp.browardschools.com/esstorage/3151-181/presentation/3151TequestaTraceMiddle_AshleyWater%20pollution.doc
http://capital.osd.wednet.edu/media/capital/staff/jansen/ib_chemistry/class_powerpoints/Topic_4.3._Network_macro_Covalent_Bonding.docx
http://olympia.osd.wednet.edu/media/olympia/departments/science/smith/biochem/carbon_compounds.doc
https://www.nd.gov/espb/TeacherSupport/Mentoring/MentorTraining%20PowerPoint.docx
http://www.schsl.org/2013/pp2014SBweb.pps
https://www.iata.org/whatwedo/Documents/ICH/SIS%20P3%20-%20RA43%20-%20Introduction%20to%20SIS.doc
http://www.med.navy.mil/dha_dhits/NavyDaysMurderboard%20Document%20Library/ND11_Governance%20Primer%202010-12-21.docx
http://plantationgeneral.com/util/documents/Surviving_Sepsis.docx
http://www-hep.physics.uiowa.edu/~vincent/courses/29273/TensorPrimer.doc
http://www.centerforspace.com/downloads/files/pubs/AAS-05-200.doc
http://capital.osd.wednet.edu/media/capital/staff/mcfadden/law_and_justice/course_outline/c18/street_law.unit_3.ch._18.torts.a_civil_wrong.docx
http://css.insttech.washington.edu/~lab/BasicSkills/AdminXPBasic.doc
http://capital.osd.wednet.edu/media/capital/staff/vandiver/JFK_Assassination.doc
http://web43.canyons.edu/Faculty/naddafpoura/Bus110/Bus110Ch10-PPP.doc
http://www.ida.net/users/rrobbins/MarkTwain.docx
https://assets.microsoft.com/en-us/customer_briefing_how_to_count_deployments_and_license_assignments.docx
http://grtc.ucsd.edu/old_essentials/2004/lecture20.pps
http://bbaworldwide.com/wp-content/uploads/2013/12/Chapter-4-Managing-Marketing-Information-to-Gain-Customer-Insights.docx
http://www.uneca-an.org/rd/presentations/Shideed%20ICARDA.doc
http://www.urhcs.org/res/files/1016/Global_Tracheostomy_Collaborative_Up-Date.docx
http://chemistry.montana.edu/~martint/BCHM444/Radioimmunoassay.doc
http://www3.canyons.edu/faculty/wonserr/Social%20Problems/Lectures/Social%20Problems%20-%20Frames%20and%20Claimsmaking.doc
http://hilo.hawaii.edu/uhh/faculty/furumo/documents/Chapter6_000.doc
http://www.coe.montana.edu/jeffrey.heys/web451/lecture1.docx
http://gaumers.com/management.php?is-abilify-a-major-tranquilizer.docx
http://cedt.iisc.ernet.in/people/kuri/Comsnets/Presentations/Unlocking-Parul.doc
http://ner6-bsa.org/wp/wp-content/uploads/2014/11/2014-Area-6-NE-Fall-Conference.docx
http://capital.osd.wednet.edu/media/capital/staff/jansen/02_chemistry/Chapter_16_notes._Molarity.doc
http://www.socalcfc.org/files/cfc_online_pledging.doc
http://www.niv-zmora.com/lectures/radiology/%F9%E9%F2%E5%F8%20%EE%F1'%204%20-%20%E3%E9%EE%E5%FA%20%E4%E7%E5%EC%E4%20%E1%F6%E4%E1%FA%205.11.07.doc
http://www.encotech.com/docs/Steam_Path_Audit_Presentation.doc
http://www.ut.edu.sa/documents/10156/2890319/lecture+1
http://www.teacherweb.com/CA/NewburyParkHighSchool/MsWhiteman/Pride-and-Prejudice-by-Jane-Austen.doc
http://www.ils.unc.edu/%7Ejpom/conf/JCDL_2007_Workshop-old.doc
http://www.gonuke.org/acad/Dose%20Equivalent.docx
http://defensecommunities.org/wp-content/uploads/2012/01/ADC-2013-IIF-RB-Eidson-Presentation-15-Jan-20131.docx
https://www.psusd.us/sites/default/files/Budget%20%20Presentation%20for%202015-2016%20-%20060915.docx
http://www.bcasbapatla.ac.in/material/Database%20management%20system.doc
http://www.eaganhs.portal.rschooltoday.com/page/6557/downloadFile/13197
http://capital.osd.wednet.edu/media/capital/staff/jansen/chap__1_notes___science_and_chemistry_2009.docx
http://www.myanmarwebdesigner.asia/how-buy-clavamox-online-without-prescription-overnight-rx.docx
http://home.apu.edu/~jbirch/BUSI240/Do%e2%80%99s%20and%20Don%e2%80%99ts%20of%20PowerPoint%20Presentations%20Rev%202.doc
http://www.parm-radiology.org/2011_PARM_AUTUMN_SYMPOSIUM_vendor_slide_show.docx
http://aluminium-dubai.com/RX/Aluminium%20ME%202013%20Speakers%20Presentation/1st%20Day/PROJESYS%20INTERNATIONAL/Presentation-Commissioning-Aluminium%20MEA%202013%20rev1.docx
http://www.franklin.kyschools.us/Downloads/Transformations%20on%20the%20Coordinate%20Plane.docx
http://capital.osd.wednet.edu/media/capital/staff/mcfadden/personal_finance/course_outline/vbpf/vb.pf.l6.shopping.docx
http://hilo.hawaii.edu/uhh/faculty/furumo/documents/ch5.doc
http://home.apu.edu/~ddavis/busi240/chap009.doc
http://capital.osd.wednet.edu/media/capital/staff/mcfadden/entrepreneurship/course_outline/whatsyouriq/1.assessing_your_social_intelligence.docx
http://seadoo-maldives.com/whisper.php?singulair-4-mg-30-comprimidos.docx
http://teacherweb.com/VA/PaulVIHighSchool/MrsWhiting/Lesson-3-7-Graphs-of-Rational-Functions-student-version.docx
http://capital.osd.wednet.edu/media/capital/staff/mcfadden/law_and_justice/co/c31/street_law.unit_5.ch._31.marriage.original.docx
http://olympia.osd.wednet.edu/media/olympia/departments/science/shelton/knee.doc
http://health.usf.edu/NR/rdonlyres/DADC955E-1220-4E96-9F17-91A51535E0EB/0/QualityAssurancePresentationSASBMarch15.docx
http://capital.osd.wednet.edu/media/capital/staff/jansen/ib_chemistry/class_powerpoints/Topic_B.7_Enzymes2014.doc
http://capital.osd.wednet.edu/media/capital/staff/jansen/chap._5_notes._electrons_part_iii_electron_configuration_1.3.doc
http://www3.canyons.edu/faculty/wonserr/Deviance/Lecture%209%20-%20Ch%2015
http://www.lisarow-p.schools.nsw.edu.au/documents/6943225/6949398/Coral%20Festival%20and%20Percussion%20Group.docx
http://capital.osd.wednet.edu/media/capital/staff/machut/Chapter_17._Magnetism._CPO.docx
http://www.brandeis.edu/hiatt/facultystaffcol/minds/WOW.doc.docx
http://www.bsj.org.jm/Portals/0/ncbj/NCBJ_Customer%20Care%20Presentation_Nov_10_2011.doc
http://washington.osd.wednet.edu/media/washington/staff/burroughs_candyce/robotics/tribot_gears_xclent.doc
http://www.emseducation.info/uploads/Pediatric_Assessment_Format.doc
http://www.tricare.mil/ocfo/_docs/T-2-1300_Case_Management.doc
http://capital.osd.wednet.edu/media/capital/staff/jansen/chap._10_notes._empericla_and_molecular.doc
http://olympia.osd.wednet.edu/media/olympia/departments/science/stevick/physical_science/practice_problems_work_and_mechanical_advantage.doc
http://miamiurbanleague.org/wp-content/uploads/2010/07/UL-Report_Card.doc
https://static-content.springer.com/esm/chp%3A10.1007/978-3-319-43577-0_1/MediaObjects/328040_1_En_1_MOESM1_ESM.docx
https://www.psusd.us/sites/default/files/Business_Services_PSUSD%20Governor's%20Budget%20Update%202.28.13.docx
https://plantationgeneral.com/util/documents/Congestive_Heart_Failure_Dr_Jancko.docx
http://www.mdmunicipal.org/DocumentCenter/View/1402
http://courses.softlab.ntua.gr/softeng/Tutorials/Reliability.doc
http://methacton.org/cms/lib/PA01000176/Centricity/Domain/121/Day%202%20-%20Intro%20to%20psychology.docx
https://webapp.browardschools.com/esstorage/0452-235/presentation/0011_Whiddon-Rogers_EnergyPlan.doc
http://nhsrcindia.org/biodata/An%20experience%20in%20operationalising%20Integrated%20Occupational%20Health%20Service%20in%20Indian%20Railways.docx
https://www.andrews.edu/leaderpart/RoundTable/2004/joust4/15/The_Role_of_Higher_Education_in_the_Formation_DOC.doc
http://dpi.wi.gov/sites/default/files/imce/school-nutrition/doc/verif_what.doc
http://www.warrencountyschools.org/userfiles/2546/Classes/79796/chsix.doc
http://www.uwgb.edu/embi/files/doc/kramer.doc
http://www.oulfc.co.uk/assets/Academy-images/Resources/unit-7-p1-m1.docx
http://www.w5online.co.uk/fs/doc/EducResource/nanotechnology/Snakes%20and%20ladders%20rules.doc
http://www.ecaa.ee/public/Part-M_Continuing_Airworthiness.docx
http://spacegrant.arizona.edu/sites/spacegrant.arizona.edu/files/documents/opportunities/symposium/2014/presentations/Session%20A%20-%20ASCEND/[A-20]%20Morris
http://hypercoils.com/DOC/Hyperco_Carbon-Composite.doc?gsleadDesc=Product+Presentation
http://www.goes-r.gov/downloads/GOES-R_Series_Program/2015/GOES-R_BrownBag_20150701_Kuligowski.docx
http://capital.osd.wednet.edu/media/capital/staff/jansen/chap._27_notes._class_mammalia.doc
http://olympia.osd.wednet.edu/media/olympia//departments/science/smith/bioethics/bioethics_lesson_8.doc
http://www.brandeis.edu/hiatt//facultystaffcol/minds/WOW.doc.docx
http://www.lmhpco.org/blahdocs/uploads/medpac_11december2009_2116.doc
http://hazwastemanagement.info/Powerpoint/chapter8.doc
http://www.acepidemiology.org/meetings/2007Miami/documents/HPV_Policy_9_17_07.doc
http://www.upenn.edu/computing/group/nptf/archive/2009/may04/may04nptf.doc
https://www.tdi.state.tx.us/fire/documents/fmclasssafe.doc
http://home.apu.edu/~jsimons/Bio101/noahsark.DOC
http://health.usf.edu/NR/rdonlyres/7E3BED8B-D667-42C9-8840-1FF00D604974/0/ConflictofInterestBioEthicsClass020607II.doc
http://www.srhsfalcons.org/ourpages/auto/2015/9/8/47271854/MODIFIERS%20notes%20and%20exercises.docx
https://ncar.ucar.edu/sites/default/files/NCARDayBio_Brown_Potts.doc
http://watecsolutions.com/wp-content/uploads/2014/10/Accounting-Training.docx
http://www.brgs.me/departments/schemes/year12/history/1947-turningpointforlabour.doc
http://engineering.uprm.edu/inme/vgoyal/inme3810/Online_inme3810/NXTutorials/UGS_NX_Tutorial_1.docx








share|improve this question













share|improve this question




share|improve this question








edited Nov 6 '17 at 7:09

























asked Nov 6 '17 at 1:11









danone

1069




1069











  • Easiest way to force the constraint would be to have the mysql server deal wtih having only unique values in the column. ALTER TABLE mytbl ADD UNIQUE (columnName);
    – ivanivan
    Nov 6 '17 at 1:58










  • delimiter is space I guess in my text file how can I use this function with text file ?
    – danone
    Nov 6 '17 at 7:27











  • You don't. You run that on your mysql table and the mysql server will keep the contents of that column unique
    – ivanivan
    Nov 6 '17 at 13:15
















  • Easiest way to force the constraint would be to have the mysql server deal wtih having only unique values in the column. ALTER TABLE mytbl ADD UNIQUE (columnName);
    – ivanivan
    Nov 6 '17 at 1:58










  • delimiter is space I guess in my text file how can I use this function with text file ?
    – danone
    Nov 6 '17 at 7:27











  • You don't. You run that on your mysql table and the mysql server will keep the contents of that column unique
    – ivanivan
    Nov 6 '17 at 13:15















Easiest way to force the constraint would be to have the mysql server deal wtih having only unique values in the column. ALTER TABLE mytbl ADD UNIQUE (columnName);
– ivanivan
Nov 6 '17 at 1:58




Easiest way to force the constraint would be to have the mysql server deal wtih having only unique values in the column. ALTER TABLE mytbl ADD UNIQUE (columnName);
– ivanivan
Nov 6 '17 at 1:58












delimiter is space I guess in my text file how can I use this function with text file ?
– danone
Nov 6 '17 at 7:27





delimiter is space I guess in my text file how can I use this function with text file ?
– danone
Nov 6 '17 at 7:27













You don't. You run that on your mysql table and the mysql server will keep the contents of that column unique
– ivanivan
Nov 6 '17 at 13:15




You don't. You run that on your mysql table and the mysql server will keep the contents of that column unique
– ivanivan
Nov 6 '17 at 13:15















active

oldest

votes











Your Answer







StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "106"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
convertImagesToLinks: false,
noModals: false,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);













 

draft saved


draft discarded


















StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f402744%2fread-text-file-and-insert-only-unique-ones-into-mysql-table%23new-answer', 'question_page');

);

Post as a guest



































active

oldest

votes













active

oldest

votes









active

oldest

votes






active

oldest

votes















 

draft saved


draft discarded















































 


draft saved


draft discarded














StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f402744%2fread-text-file-and-insert-only-unique-ones-into-mysql-table%23new-answer', 'question_page');

);

Post as a guest













































































McWxZLS0IrP Zxq 8 CM5QHnm,GB8QdtXh,J
Y WOH0bas4ajbad HlyKE,d,VLOLfO3spxfvWUkLI3oIqn12o8w Z

Popular posts from this blog

How to check contact read email or not when send email to Individual?

How many registers does an x86_64 CPU actually have?

Displaying single band from multi-band raster using QGIS