2

I'm losing my mind. I've tried the verified answer provided here: Default value for empty integer fields when importing CSV data in MySQL

Here is the screenshot of my version of the SQL Query that I'm trying to do. But I keep getting the same error and I don't know the reason why. I based my query on the link I provided above. Please help me. All responses are highly appreciated.

enter image description hereI've already created the table, here is the describe of the table.

enter image description here This is the test query. enter image description here This is the test data.

It doesn't also work for this one.

Improve this question
12
  • most probably your table field doesnt allow nulls, show us your create table? also show us what query are you using. My suggestion, try to create a basic sample with few fields and start adding things from there when you make it work. Commented Nov 15, 2016 at 14:38
  • @JuanCarlosOropeza I've edited it and provided the 'describe' of the table that I created. Sorry for bad english Commented Nov 15, 2016 at 14:43
  • @JuanCarlosOropeza any idea on how to fix this? Please help. Commented Nov 15, 2016 at 22:37
  • I told you try to create a smaller sample, very few field and make it work, then start adding fields. Only seeing your query cant see the problem Commented Nov 16, 2016 at 1:39
  • @JuanCarlosOropeza I've tried it and the same goes for the test data using the same query. Check the edit that I've made. Thank you so much for responding. Commented Nov 16, 2016 at 4:43
Related questions
199
MySQL load NULL values from CSV data
2
null values after csv import
8
Default value for empty integer fields when importing CSV data in MySQL
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.