title: Copy and Paste Rows into Same SQL Table with Different Values
body: <p>I wrote an application for resident housing at a college. In one of the tables (rooms) I have a list of all the rooms and their current/max occupancy. Now, I've added a new column called &quot;semester&quot; and set all of the existing rows to have a semester value of &quot;fall.&quot; Now I want copy and paste all of these rows into the table but change the semester value to &quot;spring.&quot; The result should be twice as many rows as I started with - half with fall in the semester value and half with spring. Wondering what the best way to accomplish this is?</p>