How do I migrate the content of a SQL table?
You can achieve it using the Feeds module.


  
  Import or aggregate data as nodes, users, taxonomy terms or simple database records.
  Import or aggregate CSV files
  Create nodes, users, taxonomy terms or simple database records from import
  Extensible to import any other kind of content
  Granular mapping of input elements to Drupal content elements
  Exportable configurations
  Batched import for large files
  


Reference


Importing data from a comma separated value (CSV) file into one multi-value field.
Importing content with the feeds module