Home Discussion Discuss: Change Column Name of a Table

  • From java changing a column name in mysqlPhill Prescott May 23, 2012 at 3:36 AM

    I downloaded the code located on the internet page: http://www.roseindia.net/jdbc/jdbc-mysql/ChangeColumnName.shtml 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? Thanks.

Post your Comment

Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
Related Articles