Re: AlterTable Structure Across Multiple DBs

2006-03-31 Thread mysql
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

AlterTable Structure Across Multiple DBs

2006-03-30 Thread Jason Dimberg
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