Answer the question
In order to leave comments, you need to log in
Bulk query mysql database?
Good afternoon, tell me please.
There is a base 2 tables s_products and s_variants The s_products
table has a created column of the timestamp type The s_variants
table has a price column
What query should be sent to replace the value in the s_products table with the created row with a new date, if the price value is higher than 0, it will be in the s_variants table
Bulk replace the date of all goods without meaning
UPDATE s_products SET created = NOW()
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question