title: Created Table with new Column but needs to replaced by Old column
body: <p>Created a Table with <code>ModifiedItems</code> as a <strong>New Column</strong> which has same kind of data as the <code>Items</code> column of the <em>same table</em> </p>
  
  <p>Old table is like this </p>
  
  <pre><code>ID                      Items                     name
  1                        -- Data --                 Some Name  
  2                        -- Data --                 Some Name  
  3                        -- Data --                 Some Name  
  4                        -- Data --                 Some Name  
  </code></pre>
  
  <p>new table</p>
  
  <pre><code>ID                      Items                     name                  newitems
      1                        -- Data --             Some Name         --data--
      2                        -- Data --             Some Name         --data--  
      3                        -- Data --             Some Name         --data--  
      4                        -- Data --             Some Name         --data-- 
  </code></pre>
  
  <p><code>newitems</code> column is dynamically crated through query to remove some items from the <code>items</code> column, now <em>how i can remove the items column and rename the <code>newitems</code> column to items column and commit it permanent so change stays there,</em> </p>
  
  <p>i do want to use <code>update</code> as it is handling my records because of too much of data </p>