1

I am facing an error when I passed the following syntax in MySQL:

ALTER TABLE store MODIFY (DOB char(40)) ;

I am attaching a screenshot too because then you can see that the column DOB is having all rows NULL in it. Even after that Data type isn't changing.

enter image description here

See in yellow is my syntax. Earlier, DOB was an integer. See all the rows are NULL. Then why the error! Please, help even if you feel it is a silly question. I am just a school going kid who has this MySQL as my subject and I don't have any tutor too.

Improve this question
1

1 Answer 1

Reset to default
1

In your image you have far to many parenthesis

ALTER TABLE store MODIFY DOB char(40);

The parenthesis you put around column name and type is not valid.

Improve this answer
1
  • Thank you very much. It worked.
    – Crazy_koala
    Commented Oct 31, 2020 at 11:41

Not the answer you're looking for? Browse other questions tagged or ask your own question.