Date become 0000-00-00 and not replace duplicate rows

Dear Bro

please help, Date become 0000-00-00 and not replace duplicate rows when im import CSV file to table

Did you try both methods "server" and "client"?

Dear Bro

server is like that and client its worse

Did you check the control characters (line terminator, field terminator), as the message suggests?

all blanks bro..

can you try to import it to?

Most probably not, because your file contains a double quote at the beginning and at the end of each line. This is nothing which you can tell HeidiSQL in that dialog. You can remove these quotes and try again.

wow you wright, actually the csv file from dbvis export.. im using excel to open it when i try paste to notepad i found double quote like u said.. hmmm

so how about the data who note replace the duplicates bro?

so how about the data who note replace the duplicates bro?

sorry?