Forum Moderators: open

Message Too Old, No Replies

import fields with commas into mysql with phpmyadmin

import mysql commas phpmyadmin quotes

         

babushka

4:11 pm on Mar 7, 2007 (gmt 0)

10+ Year Member



I'm a novice mysql user and I have two questions that I can't seem to find the answers to.

I figured out how to import a tab delimited file, but fields with commas in them get double quotes wrapped around them when they are inserted into the database. Why does it do that and is there a way to prevent it?

Secondly, I have a field with date/time info that was exported from a timestamp column. That field will not import, it just shows all zeros after import. The field is set for update on current timestamp. Is there a way to import it?

thanks