Member Avatar for akhoa168

Hi everybody!
I have a trouble with my work. I have a file data CVS, and i want to cover to a table in mysql.
But in my file CVS have some special character : /t, ",
Please help me!
Thank a lot!
mysql>load data local infile 'price.csv' into table product fields terminated by '\t' enclosed by ',' lines terminated by '\n';

  • 2 Contributors
  • 1 Reply
  • 73 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by subashvns
Member Avatar for subashvns

Hi everybody!
I have a trouble with my work. I have abalence binary tree for mlm project, and i want to how solved to it problem.
Please help me!
Thank a lot!
my batabase id,dmecode, proposal name

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.