Mysql Workbench import CSV 0 record imported
I'm using MySql workbench to import CSV files all the time. And it's always working perfectly besides the only I issue Im having now is, there's a CSV file would not get imported. No error occured during the import process. But when import finished, it shows 0 record imported. I've checked the table columns so I'm sure the data type match the CSV file. What did I miss?
csv mysql-workbench
asked Jul 12 '17 at 7:28
ZhenyuZhenyu
17929
add a comment |
I'm using MySql workbench to import CSV files all the time. And it's always working perfectly besides the only I issue Im having now is, there's a CSV file would not get imported. No error occured during the import process. But when import finished, it shows 0 record imported. I've checked the table columns so I'm sure the data type match the CSV file. What did I miss?
csv mysql-workbench
asked Jul 12 '17 at 7:28
ZhenyuZhenyu
17929
add a comment |
I'm using MySql workbench to import CSV files all the time. And it's always working perfectly besides the only I issue Im having now is, there's a CSV file would not get imported. No error occured during the import process. But when import finished, it shows 0 record imported. I've checked the table columns so I'm sure the data type match the CSV file. What did I miss?
csv mysql-workbench
asked Jul 12 '17 at 7:28
ZhenyuZhenyu
17929
I'm using MySql workbench to import CSV files all the time. And it's always working perfectly besides the only I issue Im having now is, there's a CSV file would not get imported. No error occured during the import process. But when import finished, it shows 0 record imported. I've checked the table columns so I'm sure the data type match the CSV file. What did I miss?
csv mysql-workbench
csv mysql-workbench
asked Jul 12 '17 at 7:28
ZhenyuZhenyu
17929
asked Jul 12 '17 at 7:28
ZhenyuZhenyu
17929
asked Jul 12 '17 at 7:28
ZhenyuZhenyu
17929
asked Jul 12 '17 at 7:28
ZhenyuZhenyu
17929
asked Jul 12 '17 at 7:28
ZhenyuZhenyu
17929
17929
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
OK. It was because I datatime format didn't match that in CSV file. It weird because I noticed it at first place, then I unmarked the date column to imported, it seems even you unmark the column, the mysql workbench still take that column into consideration.
answered Jul 12 '17 at 7:49
ZhenyuZhenyu
17929
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
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
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1229070%2fmysql-workbench-import-csv-0-record-imported%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
OK. It was because I datatime format didn't match that in CSV file. It weird because I noticed it at first place, then I unmarked the date column to imported, it seems even you unmark the column, the mysql workbench still take that column into consideration.
answered Jul 12 '17 at 7:49
ZhenyuZhenyu
17929
add a comment |
OK. It was because I datatime format didn't match that in CSV file. It weird because I noticed it at first place, then I unmarked the date column to imported, it seems even you unmark the column, the mysql workbench still take that column into consideration.
answered Jul 12 '17 at 7:49
ZhenyuZhenyu
17929
add a comment |
OK. It was because I datatime format didn't match that in CSV file. It weird because I noticed it at first place, then I unmarked the date column to imported, it seems even you unmark the column, the mysql workbench still take that column into consideration.
answered Jul 12 '17 at 7:49
ZhenyuZhenyu
17929
OK. It was because I datatime format didn't match that in CSV file. It weird because I noticed it at first place, then I unmarked the date column to imported, it seems even you unmark the column, the mysql workbench still take that column into consideration.
answered Jul 12 '17 at 7:49
ZhenyuZhenyu
17929
answered Jul 12 '17 at 7:49
ZhenyuZhenyu
17929
answered Jul 12 '17 at 7:49
ZhenyuZhenyu
17929
answered Jul 12 '17 at 7:49
ZhenyuZhenyu
17929
17929
add a comment |
add a comment |
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
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
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1229070%2fmysql-workbench-import-csv-0-record-imported%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
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
Required, but never shown
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
Required, but never shown
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
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
