Re: Converting varchar field into primary key

2006-05-16 Thread Jonathan Mangin
- 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: > > >>>

Re: Converting varchar field into primary key

2006-05-16 Thread gerald_clark
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

Re: Converting varchar field into primary key

2006-05-16 Thread Martijn Tonies
> > > 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

Re: Converting varchar field into primary key

2006-05-16 Thread Jonathan Mangin
> > 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

Re: Converting varchar field into primary key

2006-05-16 Thread Martijn Tonies
> 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

Converting varchar field into primary key

2006-05-16 Thread Kim Kohen
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