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)
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)