502100 MySQL queries for price update and extra info

Part one:

I would like to update prices in a database (part of Joomla/Virtuemart). I uploaded the new prices to a table "jos_entra_prijs" (see [url removed, login to view]). The prices that need to be updated are in "jos_vm_product_price" (see [url removed, login to view]) The two tables can be linked via "jos_vm_product" (see [url removed, login to view]).

jos_vm_product and jos_vm_product_price share product_id

jos_vm_product and jos_entra_prijs share product_sku (same as artikelnr)

For this operation I like to have the SQL queries.

Part two:

I like to extend the field product_s_desc (in jos_vm_product) with the text " ean: " and the content of field "ean-code" from jos_ean_prijs.

I would like the SQL queries to accomplish this.

Beceriler: Her şey Kabul, Joomla, MySQL, SQL, Virtuemart

Daha fazlasını gör: sql price, update virtuemart, sql queries, sql mysql, queries, info update, database queries, sql update text, sql update field text, update database joomla, update code sql, sql operation, queries database, update text sql, sql update text field, mysql update field, table queries, update field sql field field, sql update text text, virtuemart table joomla, queries sql, joomla extend, update sql code, joomla table mysql, mysql product database

İşveren Hakkında:
( 14 değerlendirme ) Blaricum, Netherlands

Proje NO: #2248021



Hi, i can do this job right now

%selectedBids___i_period_sub_7% gün içinde 30%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(0 Değerlendirme)