Developer forum

Forum » CMS - Standard features » Correct SQL query to copy product id value to product number field

Correct SQL query to copy product id value to product number field

E-mail notifications
Hans Ravnsfjall
Hans Ravnsfjall
Reply
Posted on 07/05/2019 14:07:19

Hi

Sorry to bother you with such a "simple" question, but I don´t have an overview of the database, but maybe somebody could help?

 

What would be the SQL query to copy the value from productid to the field number?

 

/Hans


Replies

 
Imar Spaanjaars Dynamicweb Employee
Imar Spaanjaars
Posted on 07/05/2019 14:16:32
Reply
This post has been marked as an answer

UPDATE EcomProducts SET ProductNumber = ProductID ?

Votes for this answer: 1
 
Hans Ravnsfjall
Hans Ravnsfjall
Posted on 07/05/2019 14:20:28
Reply

Thank you Imar :)

/Hans

 
Hans Ravnsfjall
Hans Ravnsfjall
Posted on 07/05/2019 14:29:47
Reply

And now I see, that in search and replace - you can see all tables and all columns :) so that will be a huge help in the future

 

 

 
Nicolai Pedersen
Posted on 08/05/2019 03:05:34
Reply

Hi Hans

You can also so the database layout in Datalist module - under connections - see all tables and their fields.

BR NIcolai

 

You must be logged in to post in the forum