Re: Extra space added on import
| From: | Hugh Bothwell | Date: | Sat, 18 May 2002 18:01:04 +0000 |
| Subject: | Re: Extra space added on import | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-13857@lists.php.net to get a copy of this message | ||
"Jerry" <jerrywin5@yahoo.com> wrote in message
news:3CE5D89D.3327C274@yahoo.com...
> Hello,
>
> When I import a comma delimited text file into a table using
> MySQL Front, a space is added to one of the fields which is a
> varchar field. How can I keep this from happening?
after importing the table, do an UPDATE and TRIM()
the field.