CODEWITHSUNDEEP
mysql
Chelsea Jorgenson
Chelsea Jorgenson

Reputation: 3

I'm using the ALTER TABLE statement and having issues SQL

I am attempting to use ALTER TABLE in MySQL and having no luck. Any feedback is much appreciated.

ALTER TABLE customers
ALTER COLUMN Phone VARCHAR(200) NOT NULL

I can't seem to figure out what is wrong. I already tried:

ALTER TABLE customers
ALTER COLUMN Phone VARCHAR(200) [NOT NULL]

and 

ALTER TABLE customers
ALTER COLUMN Phone VARCHAR(200) NOT NULL;

Upvotes: 0

Views: 35

Answers (1)

Ahmed Jamal
Ahmed Jamal

Reputation: 89

Try this if you're using MySQL

ALTER TABLE customers MODIFY COLUMN phone VARCHAR(200) NOT NULL;

Upvotes: 2

Related Questions