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

Sure it can. However at this moment we have no idea of what DATA1,2,3,4 really are? Dates,integers,floats,characters? Figuring that stuff out is important. In the DB, what can go in each column matters.

BTW, what did you do to create this temporary table?

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

Replies are listed 'Best First'.
Re^8: Sequential data read in MySQL/Perl
by chacham (Prior) on Jul 07, 2016 at 12:58 UTC

    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).

[reply]
      Thanks. That code seems to be doing the trick.
[reply]

In Section Seekers of Perl Wisdom