mysql query error in where statement

Question

I am trying to get my query correct in phmyadmin before using it in my code and i get the following error, although i know the column exists

Error
SQL query:


UPDATE 
tendesig_zink_dev.euid0_hikashop_product 
SET 
tendesig_zink_dev.euid0_hikashop_product.product_quantity = tendesig_zink_production.euid0_hikashop_product.product_quantity
WHERE 
tendesig_zink_dev.euid0_hikashop_product.product_id = tendesig_zink_production.euid0_hikashop_product.product_id

MySQL said: Documentation

#1054 - Unknown column 'tendesig_zink_production.euid0_hikashop_product.product_id' in 'where clause'

Do you really have a column named euid0_hikashop_product.product_id? — Rahul
– Rahul, Commented Jul 22, 2014 at 19:32
yes (database)tendesig_zink_production.(table)euid0_hikashop_product.(column)product_id — TEN Design
– TEN Design, Commented Jul 22, 2014 at 19:34

pkatsourakis · Accepted Answer · 2014-07-22 19:45:23Z

2

The reason you are getting an unknown column error is because your query does not know about the table tendesig_zink_production.euid0_hikashop_product. Try using this query

UPDATE 
tendesig_zink_dev.euid0_hikashop_product, tendesig_zink_production.euid0_hikashop_product
SET 
tendesig_zink_dev.euid0_hikashop_product.product_quantity = tendesig_zink_production.euid0_hikashop_product.product_quantity
WHERE 
tendesig_zink_dev.euid0_hikashop_product.product_id = tendesig_zink_production.euid0_hikashop_product.product_id

answered Jul 22, 2014 at 19:45

pkatsourakis

1,0828 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

mysql query error in where statement

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related