A
A
ART42018-05-28 15:55:23
MySQL
ART4, 2018-05-28 15:55:23

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()
52e2059433.png320a2cf0c8.png

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question