title: How to insert values in a table with dynamic columns Jdbc/Mysql
body: <p>I want to add values in a table that has dynamic columns.
  I managed to create a table with dynamic columns but I cannot figure out how to insert data.</p>
  
  <pre><code>//Create Table
  
  sql = "CREATE TABLE MyDB.myTable" +
          "(level INTEGER(255) )";
  
          int columnNumber = 5; //Number of columns
  
            //Add columns
  
          for (i=0;i&lt;columnNumber;i++){
                String columnName = "Level_" +i:
                String sql = "ALTER TABLE MyDB.myTable ADD " + columnName + " INTEGER(30)";
      }
  
  //Insert Data
  
  //How to insert data dynamically, without knowing the number of columns?
  </code></pre>