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