Jump to content


Photo

[SOLVED] Insert a customer ID in existing table


  • Please log in to reply
1 reply to this topic

#1 TecTao

TecTao
  • Members
  • PipPipPip
  • Advanced Member
  • 144 posts

Posted 22 October 2006 - 03:32 AM

I've imported a database file into a mysql database.  All is fine except that the purchased database does not have a customer ID seperate for the primary key ID.

I don't want to use the primary ID as the customer ID the column is bizID

Any suggestions to either copy the primary key ID column numbers (1,2,3,4 etc) to the bizID column, or to insert or update the table with an uploaded sql or txt file.

Thanks for all help in advance.
m
Michael Conway
<a href="http://www.tectaodes...gns.com">TecTao Designs<br>Website Design and Internet Marketing Strategies</a>

#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 22 October 2006 - 08:33 PM

I'm not sure I understand the problem you're trying to describe... you have a field that holds two values, or vice versa?
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users