need to be carefull that you do not loose any multiple
values in your set, as varchar will only hold one value at
a time.
HTH
Keith
In theory, theory and practice are the same;
in practice they are not.
On Thu, 30 Mar 2006, Jason Dimberg wrote:
> To: mysql@lists.mysql.com
> From: Jas
I have about 25 databases with the same structure and occasionally need
to update the table structure. For example, I recently found a mistake
in a field that was of type SET and needed to be VARCHAR. I will now
need to edit each table. Is there an easy method to alter table
structure across