@laptop alias:
Thank you for you suggestion. Again, I just do experience, success and fail so many times :). I think that the " make mysql confused but sometime it can work.
I think that my data excel sheet files are so complicated that I need to revise it before come back to this topic with more information for you.
@bilal shajahan:
I have try your suggestion, but it seems that mysql cannot work with other delimiters(?). I have try with the delimiter *. And mysql return with the error "invalid integer *0*" (I changed my query to
enclosed by '*'
).
After investigate my csv file again, I think that this file is too long (sometime, the row is truncated). After copy its content to the .txt file, it seems work well. However, this method is not stable.
Thank you for you help
Regards,
Khanh