Alter mysql table default value and NULLvalue?

Question

How can i make a table field with default value "none" and null value "no"?

When i create a table with following code it always add default value NULL and null to yes

ALTER TABLE `table_name` ADD `test` INT(11) AFTER `test1`

An integer column cannot have 'none' as default value, since 'none' is a string. — Lorenz Meyer
– Lorenz Meyer, Commented Jul 23, 2015 at 14:55

vinz · Accepted Answer · 2015-07-23 14:55:26Z

1

ALTER TABLE `table_name` ADD `test` INT NOT NULL AFTER `test1`;

answered Jul 23, 2015 at 14:55

vinz

5663 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Kibadachi · Accepted Answer · 2015-07-23 14:53:04Z

1

ALTER TABLE myTable
ALTER column SET DEFAULT 'none'.

For replacing NULL with NO you don't have to alter the table just do it in your query :

SELECT COALESCE(columnWhichisNull,'no'))
FROM myTable ;

COALESCE checks if a value from a column is null and replaces it with your desired character

answered Jul 23, 2015 at 14:53

Kibadachi

1856 bronze badges