Jump to content


This topic is now archived and is closed to further replies.


[SOLVED] Insert a customer ID in existing table

Recommended Posts

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.

Share this post

Link to post
Share on other sites
I'm not sure I understand the problem you're trying to describe... you have a field that holds two values, or vice versa?

Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.