php - preventing duplicate row insertion in mysql while importing csv file -

-

preventing duplicate row insertion in mysql while importing csv file.i want insert data mysql table via importing csv file. how prevent duplicate row insert?

create unique index in column might have dups, then

load data infile 'file.csv' ignore table table_name fields terminated ',' enclosed '"' escaped '"' lines terminated '\n';

Comments

Post a Comment

Popular posts from this blog

Fail to load namespace Spring Security http://www.springframework.org/security/tags -

-
i have problem namespace of spring security on xhtml page. don't understand why can't load uri, , have following issue: whitelabel error page application has no explicit mapping /error, seeing fallback. tue jul 21 16:58:12 utc 2015 there unexpected error (type=not found, status=404). please need help! possible uri has been changed? best regards you using incorrect namespace url. correct url http://www.springframework.org/schema/security the error page seeing spring source website since not recognize url. try visiting http://www.springsource.org/security/tags in browser update : spring security tags used in jsp page correct tag lib declaration is: <%@ taglib prefix="sec" uri="http://www.springframework.org/security/tags" %>
Read more

Maven Javadoc 'Cannot find default setter' and fails -

-
i'm trying generate javadocs maven project, , i'm running error every time. unable parse configuration of mojo org.apache.maven.plugins:maven-javadoc-plugin:2.10.3:javadoc parameter #: cannot find default setter in class org.apache.maven.plugin.javadoc.options.group . command i'm using mvn javadoc:javadoc root directory, pom is. i don't have groups configured @ all, or have special configuration @ all. same error whether omit plugin in pom completely, add reporting, or add build plugin. i've tried adding empty groups well, , while message changes somewhat, still appears. i ran across this question , a. don't have testng dependencies, b. i'm not using command line parameters, , c. never resolved. it selenium project, suppose there similar, can't figure out. ideas? i've included maven debug stack trace below. [error] failed execute goal org.apache.maven.plugins:maven-javadoc-plugin:2.10.3:javadoc (default-cli) on project selenium: un...
Read more

javascript - SAPUI5 Filling SmartTable with OData from XMII -

-
i'm trying fill smart table (xml view) odata our mii server. keep getting following errors: error: resource path /component-changes.json not loaded ./component-changes.json. check 'file not found' or parse errors. reason: not found - 'getchanges' failed: - this main.controller.js: sap.ui.controller("path.view.main", { /** * called when controller instantiated , view controls (if available) created. * can used modify view before displayed, bind event handlers , other one-time initialization. * @memberof sapui5.main */ oninit: function() { var omodel, oview; this.oupdatefinisheddeferred = jquery.deferred(); this.getview().byid("main").attacheventonce("updatefinished", function(){ this.oupdatefinisheddeferred.resolve(); }, this); sap.ui.core.uicomponent.getrouterfor(this).attachroutematched(this.onroutematched , this); var omodel, oview; omodel = new sap.ui.model.odata.odatamodel("...
Read more