title: How to create a new column with the table name as value - SQL
body: <p>first of all I am new to using SQL.
  I already looked on the internet and found that I could insert a new column into a tab by using the <code>ALTER TABLE</code> function. Unfortunately, I don't think this is what I'm looking for since I do not want to modify the already existing table. What I'm looking for is really simple but I don't know how to do it in SQL since I mostly use R.</p>
  <p><strong>example :</strong></p>
  <p>table name = <code>dataset1</code></p>
  <p>the current data :</p>
  <pre><code> ID     NAME SALARY
    1     John 100000
    2     Mike  80000
    3 Rachelle  90000
  </code></pre>
  <p>what I would like to have as my new output :</p>
  <pre><code> ID     NAME SALARY FROMDATA
    1     John 100000 dataset1
    2     Mike  80000 dataset1
    3 Rachelle  90000 dataset1
  </code></pre>
  <p>I know this is ridiculously easy but I don't want to modify the data on the server I just want to make a copy of it with a column containing the dataset name that I will save after. It can even be as simple as simply creating a column with me writting manually the name of the dataset. I know it would take me 0.01 sec with R, I feel dumb but I know nothing of SQL and I have to use it today.</p>
  <p>Thanks and sorry for bothering you guys.</p>