alter a field 1

[Jblain22]

I need to change a field in a mysql table

table name hr_data
column name Reason4Leaving1

right now the column is char(30) and I need it to be
char(100)

This is what I have tried and it throws a syntax error:


Alter table hr_data modify Reason4Leaving1 char(100)

 

[ztrex]

ALTER TABLE hr_data CHANGE Reason4Leaving1 Reason4Leaving1 CHAR (100) DEFAULT '0' not null


should do the trick

 

[Jblain22]

This gave me the syntax error

syntax error near unexpected token `char(1'