Tuesday, October 2, 2012

IMPORTANT: How to save the resulting table after a MySQL Join


using HeidiSQL as the gui frontend.
http://stackoverflow.com/questions/9312684/save-table-after-use-mysql-join

save table after use mysql JOIN




SELECT prod_name,prod_desc,product_url,prod_price,img_name
FROM accu_product A, accu_product_imgs B
WHERE A.prod_id = B.prod_id
Is it possible to save the resulted table after use of join, and if yes, then what will the name of it. My query is as above.



ANSWER:


CREATE TABLE whatever_you_wantSELECT
...
;





No comments:

Post a Comment