View Single Post

   
  #1 (permalink)  
Old 04-24-2008, 06:09 PM
thelma@uwm.edu
 
Posts: n/a
Default 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
Reply With Quote