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

Question

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;

What do you mean by "have no luck"? Is there any error message? — Nico Haase, Jan 31 '20 at 06:48
It says that I have an error in my SQL Syntax, but that is all I have on my screen — Chelsea Jorgenson, Jan 31 '20 at 06:52
Does this answer your question? [How to change MySQL column definition?](https://stackoverflow.com/questions/1595372/how-to-change-mysql-column-definition) — Player_Neo, Jan 31 '20 at 08:50

score 2 · Accepted Answer · answered Jan 31 '20 at 06:47

2

Try this if you're using MySQL

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

answered Jan 31 '20 at 06:47

Ahmed Jamal

1 Answers1