Forum Replies Created
-
AuthorPosts
-
DennisMParticipant
Yes, it is working now.
Thank you,
Dennis
DennisMParticipantI have tried your suggestions with no help.
This occurs on there different computers.
Has someone at Webyog checked their servers?
DennisMParticipantWin7 64 bit
DennisMParticipantThanks Peter
I will try you dump+edit+import suggestion.
Dennis
DennisMParticipantAshwin,
Thank you for your informative reply. I wasn't aware of the Text mode.
You are also correct about the copying from Excel, I updated numerous cells by cutting and pasting from a spreadsheet. I appreciate your instructions how to do it properly.
If I can't make the corrections from within SQLyog, can you suggest any other way of doing it?
It isn't a very large database, maybe 600 records but a lot of columns over 80. It's a club membership database. I hope to someday learn enough about relational databases to split it up into two, which would remove a tremendous amount of duplicated info.
Thanks again,
Dennis
DennisMParticipantHi Peter,
Because I purchased the Professional version, I spent quite a while trying to get your 1) suggestion to work. But I kept getting error 1148 trying to do the import once a created the table.
Then I decided to try your 2) suggestion, so I downloaded the trial and gave it a go. Everything worked perfectly.
Thank you very much, also thanks for the great explanation of varchar, especially the note that the size is in bytes.
Dennis
DennisMParticipantThank you Peter,
I'm doing that now. I have another question, does the varchar datatype have a 255 length limit? The MySQL manual makes my head spin. If it does have the 255 length limit is there a datatype that has a larger one (for lengthy notes)I suppose 2000 would be plenty? The MySql Server version: 5.0.91-log
Thanks
Dennis
-
AuthorPosts