KITHUB 저장소😀

SELECT mo.order_id AS order_PK, dt.order_id AS order_FK, GROUP_CONCAT(mp.prod_name) as prod_list FROM mkds_orders mo, mkds_order_details dt, mkds_products mp WHERE dt.prod_id = mp.prod_id and mo.order_id = dt.order_id GROUP BY mo.order_id 결과

아래 옵션을 추가 --single-transaction mysqldump -d --single-transaction -uroot -p1234 testdb > testdb.sql