Read Text file and insert only unique ones into mysql table
Clash 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
shell-script shell mysql
add a comment |Â
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
shell-script shell mysql
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
add a comment |Â
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
shell-script shell mysql
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
shell-script shell mysql
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
add a comment |Â
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
add a comment |Â
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
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
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
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