mysql - Text import error -

-

good day

i have created bat file import text file mysql database , looks follows:

    sqlcmd /user root /pass password /db "mydb" /command "load data local infile 'file.csv' table tg_orders fields terminated ',' enclosed '"' lines terminated '\n'"

my problem cannot "treat consecutive delimiters one" work...

how add that?

now have got real crux of problem, not consecutive delimiter problem - it's csv file format problem.

if csv file contains fields b121,535 , not enclosed within quote marks of kind and delimeter , no amount of sql jiggery-pokery sort out problem. un-quoted fields commas always interpreted 2 separate fields unless enclosed within quote marks.

post sample line csv file causing problems , can diagnose further. failing that, export data initial system again making sure formatting correct (either enclose in speech marks or string fields)

finally, sure database mysql based , not microsoft sql? references sqlcmd.exe can find point microsoft sites in relation sql server express but, then, has different option structure (-u user rather /user). if case have saved lot of hassle putting correct information tags. if not sqlcmd.exe custom written application somewhere , problem stem that. if case can't if csv formatting correct - you're on own


Comments

Post a Comment

Popular posts from this blog

design - Custom Styling Qt Quick Controls -

-
Image
i have custom design qt quick controls. example, change background colour of tool bar, since hate default design. how can that? in qt quick controls, there limited styling available via qt quick control styles items, buttonstyle , checkboxstyle , etc. at moment, other styles require delving qt sources , messing internal details. here complete example of how 1 might modify toolbar's style. main.qml import qtquick 2.1 import qtquick.layouts 1.0 import qtquick.controls 1.0 applicationwindow { toolbar: toolbar { id: toolbar component.oncompleted: toolbar.data[0].item.children = [newrectangle]; property item _newrectangle: rectangle { // rectangle within toolbarstyle's panel // gleaned from: // http://qt.gitorious.org/qt/qtquickcontrols/source/ // c304d741a27b5822a35d1fb83f8f5e65719907ce:src/styles/base/toolbarstyle.qml id: newrectangle anchors.fill: parent...
Read more

Unable to remove the www from url on https using .htaccess -

-
i want remove www site url. ie. https://www.domainname.com.au https://domainname.com.au . i have tried various .htacces code nothing work me. here present code remove www http not work https. rewriteengine on rewritebase / rewritecond %{http_host} ^www\.(.*)$ [nc] rewriterule ^/(.*)$ http://%1/$1 [r=301,l] rewritecond %{https} off rewriterule ^(.*)$ https://domainname.com.au/$1 [r=301,l] rewriterule ^code-of-conducts/(.*)/$ code-of-conducts.php?type=$1 rewriterule ^parents/post-a-job/(.*)/edit/$ parents/post-a-job.php?action=edit&id=$1 rewriterule ^parents/post-a-job/(.*)/$ parents/post-a-job.php?job_type=$1 rewriterule ^parents/open-jobs/(.*)/delete/$ parents/open-jobs.php?action=delete&id=$1 rewriterule ^parent-profile/(.*)/$ parent-profile.php?id=$1 rewriterule ^parents/job-details/(.*)$ parents/job-details.php?applied_id=$1 rewriterule ^sitterprofile/(.*)/$ sitterprofile.php?id=$1 rewriterule ^sitter/job-board/state/(.*)/page/(.*)/$ sitter/job-board.ph...
Read more