title: MySQL to MariaDB - Dynamic Columns?
body: <p>I'm trying to transfer data from <code>old_table</code> to <code>table</code> with some of the data being in dynamic columns for future imports</p>
  
  <pre><code>INSERT INTO `table` (`col_1`,`col_2`,etc....   `attributes`)
  SELECT `col_1`,`col_2`,etc....     COLUMN_CREATE('name',`col_99` AS UNSIGNED,'name2',`col_100` AS CHAR)
  FROM `old_table`
  </code></pre>
  
  <p>The only documentation on dynamic tables is basically</p>
  
  <pre><code>COLUMN_CREATE('name',1 AS UNSIGNED) 
  </code></pre>
  
  <p>Which is not a very "dynamic" example...</p>
  
  <p>Open to other solutions but NOT JSON, prefer MariaDB though as it is essentially MySQL which I'm used to</p>
  
  <p>EDIT: many thanks for the answers, but for further information I am trying to use this approach documented (badly) here: <a href="https://mariadb.com/kb/en/dynamic-columns-functions/" rel="nofollow noreferrer">https://mariadb.com/kb/en/dynamic-columns-functions/</a> </p>
  
  <p>Edit 2: I'm wondering whether EAV might be the only solution, as I seem to be hitting a wall with MariaDB Dynamic Columns, I can't find any more documentation or guides anywhere!</p>
  
  <p>Edit 3: Not having any luck still with these dynamic columns? MariaDB is really confusing!</p>