CGI/Perl Guide | Learning Center | Forums | Advertise | Login
Site Search: in

  Main Index MAIN
INDEX
Search Posts SEARCH
POSTS
Who's Online WHO'S
ONLINE
Log in LOG
IN

Home: Perl Programming Help: Beginner: Re: [BigRedEO] Parsing CSV file - Add Concatenated field/sort: Edit Log



FishMonger
Veteran / Moderator

Mar 22, 2016, 1:36 PM


Views: 39034
Re: [BigRedEO] Parsing CSV file - Add Concatenated field/sort


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


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


Edit Log:
Post edited by FishMonger (Veteran) on Mar 22, 2016, 1:38 PM
Post edited by FishMonger (Veteran) on Mar 22, 2016, 1:44 PM


Search for (options) Powered by Gossamer Forum v.1.2.0

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives