How do I change a bad column name? I have a table one of whose columns is named 'interval', which is also
a mysql datatype. I don't know how easy it is to create such a table,
but it sure isn't easy to use it.
Mysql won't let me access this column in any way that I've tried: I
can't select it or update it; I can't delete it or rename it.
Do I have to recreate the whole table to get rid of it?
thanks, --thelma |