title: Split string in a column into three columns in the same table and insert it into new table
body: <p>Hello I am a beginner here.. here is my question</p>
  
  <p>I have a table "tspade" with two columns that is shown below :</p>
  
  <pre><code>No  | Unixdatetime                                      |
  
  1   | 1234567890 -1 #SUP: 2                             |
  
  2   | 2345678901 -1 #SUP: 2                             |
  
  3   | 3456789012 -1 #SUP: 3                             |
  
  4   | 4567890123 -1 5678901234 -1 #SUP: 2               |
  
  5   | 6789012345 -1 7890123456 -1 8901234567 -1 #SUP: 2 |
  </code></pre>
  
  <hr>
  
  <p>I'd like to convert that table into like this :</p>
  
  <pre><code>No  | Unixdatetime1 | Unixdatetime2 | Unixdatetime3 |
  
  1   | 1234567890    | 0             | 0             |
  
  2   | 2345678901    | 0             | 0             |
  
  3   | 3456789012    | 0             | 0             |
  
  4   | 4567890123    | 5678901234    | 0             |
  
  5   | 6789012345    | 7890123456    | 8901234567    |
  </code></pre>
  
  <hr>
  
  <p>and save that to table <code>try</code></p>
  
  <p>I used this query :</p>
  
  <pre><code>Insert Into try (No,Unixdatetime1,Unixdatetime2,Unixdatetime3)
  SELECT `No`, `Unixdatetime`,
      SUBSTRING_INDEX( `Unixdatetime` , ' -1 ', 1 ) AS Unixdatetime1,
      SUBSTRING_INDEX(SUBSTRING_INDEX( `Unixdatetime` , ' -1 ', 2 ),' -1 ',-1) AS Unixdatetime2,
      SUBSTRING_INDEX( `Unixdatetime` , ' -1 ', -1 ) AS Unixdatetime3
  FROM tspade
  </code></pre>
  
  <p>but it couldn't work...
  Any advice or help?
  Thanks in advance</p>