in reply to Re^7: Sequential data read in MySQL/Perl
in thread Sequential data read in MySQL/Perl

However at this moment we have no idea of what DATA1,2,3,4 really are

So, just store them as varchars until you figure it out. While numeric types enforce the datum to be numeric and date types enforce that it be a date, varchar has no real constraints other than length and that it be passed as a string (assuming it doesn't implicitly convert it for you).

  • Comment on Re^8: Sequential data read in MySQL/Perl

Replies are listed 'Best First'.
Re^9: Sequential data read in MySQL/Perl
by justin423 (Scribe) on Jul 07, 2016 at 16:45 UTC
    Thanks. That code seems to be doing the trick.