|
|
Posted by mick white on 10/14/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
Navigation:
[Reply to this message]
|