Yeah, pretty much, but I would keep cust_id around and start over with a true autoincrement from 1.
On 5/9/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
and this would be, in other words, the solution 2, right? > If you really want to change the customer ID, then you can always copy the > entire table to another table with a primary key set. Then simply > reference that primary key field and forget the prior one. > > -- > Steve - Web Applications Developer > http://www.sdwebsystems.com > > > On Tue, May 9, 2006 9:33 am, [EMAIL PROTECTED] said: >> hi to all, >> I have to redo a web site of one company and the structure of the >> current >> db is a little mess. >> one of them is customer id number. right now, customer table use as >> primary key cust_id column varchar(50) PRIMARY KEY (no auto increment). >> I >> really have no idea why previous developer made cust_id with letter C on >> the beggining of a number, and the number is made from date, (mdyHis) >> ?!?! >> >> What do you suggest to do: >> 1. take off letter C and keep the numbers, change cust_id to integer NOT >> NULL, add one customer with number 20000000 and then apply >> auto_increment? >> 2. replace current Cxxxxxxxxxx with INT numbers and replace the cust_id >> in >> every other table where cust_id is foreign key? >> 3. something else? >> >> Thanks for any help! >> >> -afan > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
