> -Original Message-
> From: John Berman [mailto:[EMAIL PROTECTED]
> Sent: Friday, February 11, 2005 16:22
> To: 'Tom Crimmins'
> Cc: mysql@lists.mysql.com
> Subject: RE: Remove spaces
>
> The error is simply:
>
> [JGSGB 4.1 Host] ERROR 1064:
m Crimmins [mailto:[EMAIL PROTECTED]
Sent: 11 February 2005 22:16
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: RE: Remove spaces
Please post the error because this looks correct.
---
Tom Crimmins
Interface Specialist
Pottawattamie County, Iowa
> -Original Message-
> F
s.mysql.com
> Subject: RE: Remove spaces
>
> Thanks for this
>
>
> I did this:
>
> update mc_census set surname = trim(surname)
>
> however it fails with a syntax error ?
>
> I'm on 4.1
>
> Regards
>
> John B
>
> -Original Messa
gt; Regards
>
> John B
>
> -Original Message-
> From: Homam S.A. [mailto:[EMAIL PROTECTED]
> Sent: 11 February 2005 21:29
> To: mysql@lists.mysql.com
> Subject: Re: Remove spaces
>
> update your_table
> set your_field = trim(your_field)
>
>
>
Thanks for this
I did this:
update mc_census set surname = trim(surname)
however it fails with a syntax error ?
I'm on 4.1
Regards
John B
-Original Message-
From: Homam S.A. [mailto:[EMAIL PROTECTED]
Sent: 11 February 2005 21:29
To: mysql@lists.mysql.com
Subject: Re: Remove s
update your_table
set your_field = trim(your_field)
--- John Berman <[EMAIL PROTECTED]> wrote:
> Hi
>
> I have a table with a number of fields
>
> The table is already populated, however some entries
> have got spaces both
> before and after the data.
>
> Future imports into the table will ha
Hi
I have a table with a number of fields
The table is already populated, however some entries have got spaces both
before and after the data.
Future imports into the table will have the spaces removed, however im still
stuck with my extra spaces.
I have checked the Mysql manual but could not f
