Skip to content

Instantly share code, notes, and snippets.

@csdear

csdear/INSERT INTO - Multiple Values Examples.sql

Created February 18, 2016 17:41
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save csdear/1e46bb6747607c9f03d7 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save csdear/1e46bb6747607c9f03d7 to your computer and use it in GitHub Desktop.
Download ZIP
INSERT INTO - Multiple Values, multiple rows Examples
Raw
INSERT INTO - Multiple Values Examples.sql
-- Add entries to the Camera table if you want it reflected in the dashboard. You will need the modem_id associated with each sn/meid combination
SET IDENTITY_INSERT camera ON
INSERT INTO camera (camera_id, camera_type_id, modem_id, user_id)
--VALUES (45, 1, 196, 23)
VALUES
(46, 1, 197, 23),
(47, 1, 198, 23),
(48, 1, 199, 23),
(49, 1, 200, 23),
(50, 1, 201, 23)
SET IDENTITY_INSERT camera OFF
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment