Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- converting field type in active database
- William Gill
October 30, 2005, 10:38 pm
rate this thread
to hold an integer that each bit was a 'flag'. Now I realize that the
set field type does just what I was trying to accomplish. Is it safe to
convert the field(s) from uint to set and keep their current values?
Obviously all external programming (queries) will have to be adjusted,
but it seems to make more sense to use the set type.
Re: converting field type in active database
But why not just insert a brand new field with your set type then:
See how it works out alongside the original int field.
When you are happy everything works, you can delete the old
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum