Set Value of a GENERATED column in a table with if condition in MYSQL

dip s

5y1.1kSQL

I have two columns named 'FromTime' and 'ToTime' in a Table.

I have set 'ToTime' column as Generated coulmn.

Now, I want to write an expression for this 'ToTime' column.

What I want to do is,

If 'ToTime ' is not provided while saving data to this table then it should save FromTime's value to 'ToTime' column.

If 'ToTime' is provided while saving data into the table then ToTime's value should be saved to 'ToTime' Column.

How to write this condition/expression for saving data into generated column in MYSQL.

Thank you in advance.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh5y ago
yes like shown in below example
ALTER TABLE products
ADD COLUMN TotalPrice DOUBLE
GENERATED ALWAYS AS (price*quantity) STORED;
here total price is generated column based on price and quantity column
dip s5y ago
ok. But can we generate value on condition of another column value?
Sachin Singh5y ago
generated coulmn is always based on expression including other column's value.
It doesn't allow to insert values explicitely , so how do you insert value in ToTime column , if ToTime Column will always depend on FromTime column then you can make it generated column but in your scenario you need value of this column which is actually not generated rather entered.