inner join 쿼리문 좀 봐주세요
본문
g5_shop_item (상품정보 테이블)
g5_shop_item_option (상품옵션 테이블) <=========빈테이블
g5_shop_item_option_copy (상품옵션 테이블) <======상품코드를 inner join해서 넣을 데이터 테이블
insert into g5_shop_item_option(io_id,io_type,it_id,io_price,io_stock_qty,io_noti_qty,it_use) select io_id, io_type,it_id,io_price,io_stock_qty,io_noti_qty,io_use from g5_shop_item_option_copy inner join g5_shop_item.it_id = g5_shop_item_option_copy.it_id;
syntax error나는데 구문 좀 봐주세요.
g5_shop_item_option테이블의 io_no 필드는 autoincrease라서 항목에서 뺐습니다.
답변 2
error 구문 은요?
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.it_id' at line 1
insert into g5_shop_item_option(io_id,io_type,it_id,io_price,io_stock_qty,io_noti_qty,it_use)
select io_id, io_type,it_id,io_price,io_stock_qty,io_noti_qty,io_use
from g5_shop_item_option_copy
inner join g5_shop_item
on g5_shop_item.it_id = g5_shop_item_option_copy.it_id;
※ https://h5bak.tistory.com/80
insert into g5_shop_item_option(io_id,io_type,it_id,io_price,io_stock_qty,io_noti_qty,it_use)
select io_id, io_type,it_id,io_price,io_stock_qty,io_noti_qty,io_use
from g5_shop_item_option_copy inner join g5_shop_item on g5_shop_item.it_id = g5_shop_item_option_copy.it_id;