Mar 22, 2016, 1:36 PM
Re: [BigRedEO] Parsing CSV file - Add Concatenated field/sort
I've realized I actually need to add the concatenated field to the beginning of each record first (that will become a primary key for a MySQL table)That sounds like an odd design and it sounds like the DB isn't normalized.
The date fields are in MM/DD/YYYY format so I guess I could use a date sort, but the last key needs to be based on the update-date/update-time combination.That's not the format used for a mysql date field. You'll want to reformat that before inserting into the DB.
There's no need to presort the data before inserting into the DB. The sorting should be done when you do your select statements.
(This post was edited by FishMonger on Mar 22, 2016, 1:44 PM)