Posted by mick white on 10/03/93 11:37

Joe Makowiec wrote:

> Hey, Mick!
>
> How much data do you have in the table? If it's not much, try this:
> - Dump to a CSV file
> - Purge the database
> - Add a date field at the end of the database
> - Import the CSV file to your favorite spreadsheet
> - Add a column in the spreadsheet
> - To that column, you'll input the date as "2006-" # datecell (where #
> is the concatenation operator and datecell is the cell with the date in
> it)
> - Convert months to numeric values (s/Apr/04-/)
> - Re-save the file as CSV
> - Import the CSV to MySQL
>
> BTW, don't keep a separate day-of-week column in the table. That can
> be derived from the date, thus is redundant, and is a source of
> potential errors.
>
> If you want me to help you with this, drop me a line (below).

Thanks, Joe, email en route.
Mick

[Back to original message]