how many tables? On Tue, Aug 4, 2009 at 3:44 PM, Craig White wrote: > I need to update almost all (but not quite all) records in a data table > because the dates were imported like '08/04/09' instead of '2009-08-04' > > I am looking at the mysql reference manual but it doesn't appear that it > would be easy to script a line by line 'update' from a csv file. > > Now I still have the csv files (and a copy with the dates fixed) and I > suppose I could 'find', 'delete' and then 'import' again but there are > relational records so mysql would probably prevent me from doing that > unless I suspend all relational checks when I delete those records prior > to reimporting them with the fixed dates. > > What's the best way to accomplish this? > > Craig > > > -- > This message has been scanned for viruses and > dangerous content by MailScanner, and is > believed to be clean. > > --------------------------------------------------- > PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us > To subscribe, unsubscribe, or to change your mail settings: > http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss > -- Eric Cope http://cope-et-al.com