- Original Message -
From: "gerald_clark" <[EMAIL PROTECTED]>
To: "Jonathan Mangin" <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, May 16, 2006 3:08 PM
Subject: Re: Converting varchar field into primary key
> Jonathan Mangin wrote:
>
> >>>
Jonathan Mangin wrote:
I'm creating a new MySQL database from an existing Filemaker db.
My problem is that some of the existing 'numbers' in one column (it
was a text field in FMP) have leading zeros. eg: 003, 0007, 012,
001234. I need to maintain these numbers 'as is' - complete with
zer
> > > I'm creating a new MySQL database from an existing Filemaker db.
> > >
> > > My problem is that some of the existing 'numbers' in one column (it
> > > was a text field in FMP) have leading zeros. eg: 003, 0007, 012,
> > > 001234. I need to maintain these numbers 'as is' - complete with
> > I'm creating a new MySQL database from an existing Filemaker db.
> >
> > My problem is that some of the existing 'numbers' in one column (it
> > was a text field in FMP) have leading zeros. eg: 003, 0007, 012,
> > 001234. I need to maintain these numbers 'as is' - complete with
> > zeros
> I'm creating a new MySQL database from an existing Filemaker db.
>
> My problem is that some of the existing 'numbers' in one column (it
> was a text field in FMP) have leading zeros. eg: 003, 0007, 012,
> 001234. I need to maintain these numbers 'as is' - complete with
> zeros. I've tried
Hello,
I'm creating a new MySQL database from an existing Filemaker db.
My problem is that some of the existing 'numbers' in one column (it
was a text field in FMP) have leading zeros. eg: 003, 0007, 012,
001234. I need to maintain these numbers 'as is' - complete with
zeros. I've tried al