Insert un mode dans plusieurs conteneurs

Warning

Cette opération utilise des fonctions spécifiques à Singlestore.

INSERT INTO container_mode_pivot (container_id, mode_id, created_at, updated_at)
SELECT table_col AS container_id, [mode_id], NOW(), NOW() 
FROM TABLE([1, 19, 26, 1360, 33, 32, 10, 11, 34, 31, 38, 40, 46, 37, 35, 36,
      42, 39, 1361, 1814, 13, 15, 25, 19000, 6003, 6002, 20, 1362, 1417,
      50000, 9, 12, 17, 22, 18, 14, 1389, 16, 1977, 1955, 40002, 41,
      23, 2061, 24, 21, 1400]);

Keywords

insert mode container container_mode_pivot