Jump to content

Brian Evans

Members
  • Content Count

    392
  • Joined

  • Last visited

  • Days Won

    4

Everything posted by Brian Evans

  1. The MySQL LOAD DATA statement can certainly handle all of that not sure why you think otherwise? MySQL :: MySQL 5.7 Reference Manual :: 13.2.6 LOAD DATA Statement The [{FIELDS | COLUMNS} [TERMINATED BY 'string'] [[OPTIONALLY] ENCLOSED BY 'char'] [ESCAPED BY 'char'] can handle double quotes. The SET col_name={expr | DEFAULT} section can be used for date, Boolean or other field conversions as needed.
  2. I tend to move it all into a DataModule (one per thread type/definition) so it ends up under an instance variable for that namespace wise.
×