SQL 批量插入数据语句

循环批量插入数据的SQL语句:

    insert into A(CuisID,StoID)
    select 数据值, StoID
    from B
    where StoID not in (select StoID from A)