Query for altering column to be nullabe not working

Question

I need to make column called start_date_data_id to be nullable.

I found this answer(Altering a column to be nullable) and tried to do it on described way.

Description of that column: (| start_date_data_id| bigint(20)| NO | MUL | NULL | |).

Query:

ALTER TABLE attenddb.company_group_user_settings
    ALTER COLUMN start_date_data_id bigint(20) NULL;

Error:

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'bigint(20) NULL' at line 1

Can someone tell me why is it not working?

The accepted answer in the question you referenced is for ms sql server (it says so). Had you scrolled down a little bit in the answers, you would have found the mysql specific answer as well. Anyway, linked in another question that is mysql specific only, to avoid misunderstandings. — Shadow, Sep 17 '19 at 10:25

score 1 · Accepted Answer · answered Sep 17 '19 at 10:20

1

Try this:

ALTER TABLE attenddb.company_group_user_settings
MODIFY start_date_data_id bigint(20) NULL;

answered Sep 17 '19 at 10:20

Ankit Das

640
4
16

This is working, thank you. – Jakov Sep 17 '19 at 10:21
1

Please accept it if this is the solution – Ankit Das Sep 17 '19 at 10:22
I will, but need to wait 5 more minutes. – Jakov Sep 17 '19 at 10:22
1

The reason why your code didnt work is because you are using SQL Server syntax whereas MySQL uses a different syntax. – Ankit Das Sep 17 '19 at 10:23

Query for altering column to be nullabe not working

1 Answers1