Skip to content

Instantly share code, notes, and snippets.

@dilipkrish
Created April 1, 2020 00:51
Show Gist options
  • Save dilipkrish/c103d2a452b306fe3a922c54cec5a218 to your computer and use it in GitHub Desktop.
Save dilipkrish/c103d2a452b306fe3a922c54cec5a218 to your computer and use it in GitHub Desktop.
INSERT INTO weather_recording(station_id, measurement_date, element, measured_value, measurement_flag, quality_flag,
source_flag, measurement_time)
SELECT 'US1TXDN0008'
, measurement_date
, element
, measured_value
, measurement_flag
, quality_flag
, source_flag
, measurement_time
FROM weather_recording
WHERE station_id = 'USR0000TCLD';
;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment