Default value for a text column

Question

I have a column in my table having data type as TEXT.

How can I give it a default NULL value, so that when there is not entry in the column it doesn't consume memory.

I was reading a similar question on a forum where they said column should be allowed for null values; I did that but it doesn't work..

You can use triggers [*how to give Default Text like 'not updated' to text type in sql*](http://stackoverflow.com/questions/23886364/how-to-give-default-text-like-not-updated-to-text-type-in-sql) — M Khalid Junaid, May 27 '14 at 13:03

BoltClock · Accepted Answer · 2012-01-14T06:40:05.260

41

TEXT does not support default values of anything but NULL. As such, it's implicitly DEFAULT NULL, so you should not need to change anything.

edited Jan 14 '12 at 06:40

answered Mar 09 '11 at 08:15

BoltClock

so if there is no data in the column , will it save memory ?? – Shaun Mar 09 '11 at 08:48
1

http://stackoverflow.com/questions/3466872/why-cant-a-text-column-have-a-default-value-in-mysql – Anees Sadeek Mar 16 '16 at 07:06
1

"For string types other than ENUM, the default value is the empty string" (https://dev.mysql.com/doc/refman/5.7/en/data-type-defaults.html) – Ivan Olshansky Jun 06 '20 at 13:14

1 Answers1