On Tue, 2009-08-04 at 15:46 -0700, Eric Cope wrote:
> how many tables?
>
> On Tue, Aug 4, 2009 at 3:44 PM, Craig White <craigwhite@azapple.com>
> 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?
----
one table (salesorders and at least one related table
(salesorderdetails) which as you might suspect is the line items table
for salesorders.
I need to keep the orders from 8/1/2009 through 8/4/2009 and fix the
rest but the rest have to be either deleted and imported again (probably
best) or simply updated from another file (which I have in CSV format
and the dates are fixed properly).
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
(text/plain)