mysql insert插入新形式，再也不需要拼接多重insert啦

原理是“表插表”

INSERT INTO prod_attr 
select A.* from 
(
        SELECT 
                    5                   AS prod_id,
                    1                   AS attr_id, 
                    ‘中国出版社‘         AS attr_value

        UNION

        SELECT 
                    5                   AS prod_id,
                    2                   AS attr_id,
                    ‘清华出版社‘         AS attr_value
) AS A

表结构

mysql insert插入新形式，再也不需要拼接多重insert啦

标签：