title: Insert and Select from another table in a MySQL Event (depending on date)
body: <p>For my time management system I'd like to add a new daily row into my table containing a value depending on the day of the week which is located in another table.
  The values that I want to read are located in the colums s0 - s6 (for each day of the week).</p>
  
  <p>Edit: Right now I'm at this point. New line is being added, but with "s2" instead of the value of that cell :(</p>
  
  <pre><code>INSERT INTO `table_write` (datum, soll)
  SELECT CURRENT_DATE(), CONCAT('s',DAYOFWEEK(CURRENT_DATE())-1)
  FROM `table_read` WHERE id = 51901
  </code></pre>
  
  <p>btw: The <code>-1</code> is just to get weekdays being shown 0-6 instead of 1-7. It works fine, it's just not letting me read from the table I want to read from :(]</p>
  
  <p>I've never done anything with Events in MySQL, so I'm grateful for every answer.</p>