ccarrasc/copy-row.sql

Created February 19, 2014 19:06

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/ccarrasc/9099237.js"></script>
Save ccarrasc/9099237 to your computer and use it in GitHub Desktop.

Download ZIP

(MS) SQL example to copy a row in a table and replace the value in a specific column

Raw

copy-row.sql

	INSERT INTO table (c1, c2, c3)
	(SELECT 'new c1', c2, c3
	FROM table
	WHERE c1 = 'old c1')

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment