Read Text file and insert only unique ones into mysql table

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













































































Popular posts from this blog

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

Bahrain

Postfix configuration issue with fips on centos 7; mailgun relay