I downloaded the code located on the internet page:
and have trying to use it to change the column names in several of my tables. The code worked fine for changing the index colum. When it asked the "type" of the column I put in "int" and it accepted this as correct. However when I tried the code on an mysql VARCHAR field (string field) I could not get it to work. I used everything I could think of (VARCHAR, varchar, char, string, String, literal, etc.) and it didn't like any of my entries. I kept getting the "wrong entry" message. I also rechecked the other entries carefully to make sure I was typing them in according to the spelling and capitalization I had used in the table.
Can you help me with the "type" for the VARCHAR field in mysql?
Post your Comment