Mysql change column details

mysql alter-table
Ankur picture Ankur · May 14, 2010 · Viewed 9.9k times · Source

I am trying to redefine the number of varchars a column can have (in a MySQL db).

I am doing 

alter table obj_details IMG_SRC IMG_SRC varchar(180);

I want to change the number of characters that can be used in the column IMG_SRC to 180 (it is currently 100). But I get an error saying that I should check the syntax near IMG_SRC IMG_SRC varchar(180).

Answer

Dominic Rodger picture Dominic Rodger · May 14, 2010

Why did you write IMG_SRC twice? You want:

ALTER TABLE obj_details MODIFY IMG_SRC varchar(180);

(For what it's worth the COLUMN in MODIFY COLUMN is optional, see here.)

Related questions

How to delete a column from a table in MySQL

Given the table created using: CREATE TABLE tbl_Country ( CountryId INT NOT NULL AUTO_INCREMENT, IsDeleted bit, PRIMARY KEY (CountryId) ) How can I delete the column IsDeleted?

Read More
Error renaming a column in MySQL

How do I rename a column in table xyz? The columns are: Manufacurerid, name, status, AI, PK, int I want to rename to manufacturerid I tried using PHPMyAdmin panel, but I get this error: MySQL said: Documentation #1025 - Error on …

Read More
Alter a MySQL column to be AUTO_INCREMENT

I’m trying to modify a table to make its primary key column AUTO_INCREMENT after the fact. I have tried the following SQL, but got a syntax error notification. ALTER TABLE document ALTER COLUMN document_id AUTO_INCREMENT Am …

Read More