title: How to update a entire column using row index and hardcode value in Mysql?
body: <p>I want to update the entire <strong>email</strong> column using row <strong>index + email@gmail.com</strong> formate.</p>
  <p>This is how the data in my table</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>id</th>
  <th>email</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>12</td>
  <td>abc@gmail.com</td>
  </tr>
  <tr>
  <td>23</td>
  <td>pqr@gmail.com</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>This is the output that I want</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>id</th>
  <th>email</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>12</td>
  <td>1email@gmail.com</td>
  </tr>
  <tr>
  <td>23</td>
  <td>2email@gmail.com</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I tried the below query but it did not give my expected output.</p>
  <pre><code>   ;with C as
  (
    select email,row_number() over(order by id asc) as rowid
    from cus       
  )
  update C
  set email = rowid+'email@gmail.com'
  </code></pre>
  <p>This is not only 3 rows there are more than 500 rows in my <code>cus</code> table. It is better if someone can give a solution to me without looping. Please help me to create a SQL query for this. Thank you.</p>