When you reimported the text file, did you include REPLACE? For example:
LOAD DATA INFILE 'textfile.txt' REPLACE INTO TABLE table_name;
Tracy
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of scott
Sent: Friday, March 09, 2001 4:19 PM
To: MySQL
Subject: Changing column type
I reimported the text file which should overwrite the data right which
did not work. If not how do I overwrite the data?
You are expecting an awfull lot from mysql to remember data that it
never
recorded. When you inserted something into the varchar(50) column that
was
longer than 50 it dropped the rest of the string that would not fit.
Changing the column size will not bring back the data.
ryan
> I had a column that was set to varchar(50) which ended up not being
enough
> space. So I went in and did a:
> alter table main change description description varchar(255) not null;
> It said everything went ok, I reimported the text file, but the words
stop
> after 50 characters still did I miss something or do I have to totally
> delete the column and readd it????
>
> Thanks,
> Scott
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
