You can safely change varchar to text, since they are the same data
type.
ALTER TABLE table_name CHANGE field_name field_name TEXT
But, as always, make sure you have a recent backup. There is always the
possibility that your computer will crash in the middle of the
operation due to a stray galactic neutrino that happens to collide with
a bit of your memory and cause a bit to flip.
On May 23, 2005, at 9:37 AM, Scott Purcell wrote:
Hello,
I created a table that uses a varchar(254) size field, and found out
that the customers data is being truncated. It needs to be larger.
Currently there are about 500 records (it is a description field) in
the column. Upon reading the docs, it looks like I need to use a
"text" type column.
I have never done an alter with records in a table, specifically when
it is client-data. How, or where, can I get information on how to
alter the table to be a text field, or do I need to copy all the data
to a tmp table, create a new table and copy all the data back to the
new table with a "text" column?
I have no experience with this area of sql.
Thanks,
Scott
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
