MySQL function in column default value

Question

Is it possible to use function in column default value?

I want to do something like that:

CREATE TABLE FOO ( col1 varchar(100), col2 varchar(1) NOT NULL DEFAULT SUBSTRING(col1,1,1) );

When you add value in column col1 at that time add substring value to col2 by 1 character from existing variable — Paresh Gami
– Paresh Gami, Commented Sep 5, 2014 at 11:11

juergen d · Accepted Answer · 2014-09-05 11:05:52Z

1

No, that is not possible.

Only static values are allowed and times values like current_timestamp or current_date.

answered Sep 5, 2014 at 11:05

205k40 gold badges303 silver badges377 bronze badges

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

Comments

user3485388 · Accepted Answer · 2016-11-16 21:46:33Z

1

You can create a VIEW of your table that uses your function to create the value.

answered Nov 16, 2016 at 21:46

111 bronze badge

Link only answers are discouraged. Please add more details to your post, in case the link is ever broken.