Add unique value to All product_model Fields

[ackerley1]

Hello, maybe someone on this forum can help me solve this issue.

I posted this on the OSComm forusm:

Adding Model Number via MySQL - osCommerce Community Support Forums

Essentially need to populate the product_model field with a unique numerical value.

Is there a MySQL DB query I can run that will do this for me?

Any help would be appreciated.

Rob

[Uncle Dog]

Assuming you've already ALTERed your table

UPDATE name of table in quotes SET 'product_model' = name of record id in quotes;
...should work but surely you could just reference the record id directly.

[ackerley1]

What you have listed appears to work for 1 item, but not for all of them.

Is it possible to copy values from one column (product_id) to another column (product_model)? But do it across all 2600 products in the dB?

Thanks!

[Uncle Dog]

UPDATE ? SET ? = ? should work through every record in the table.

[ackerley1]

Sorry my MySQL is not very extensive:

UPDATE product_table SET product_model = ???

Would I have to do that query for every single line (2600 of them?) or would that update each of them with a unique value?

[Uncle Dog]

No.

Apologies. I've just tested my post. The MySQL statement should be

UPDATE product_table SET product_model = product_id;

Do this once and it will alter all records.

[ackerley1]

okay... I will give it a try... after back up of course!

[ackerley1]

it worked.. now to figure out why Easy Populate contrib for OS Comm still won't work...

thanks for help...

Rob