T
T
temagadfazer2019-03-05 23:00:24
Database design
temagadfazer, 2019-03-05 23:00:24

How to prevent data entry in a column in a sql table?

There is a sql table and one column is generated depending on the others. How to disable input in this data column?

Answer the question

In order to leave comments, you need to log in

3 answer(s)
M
Melkij, 2019-03-05
@melkij

Your subd can't generate columns? For example, mysql can
In a more general case - add a trigger in which you calculate a new value and thus ignore all attempts to fix it manually.

D
Dimonchik, 2019-03-05
@dimonchik2013

in the muscle only with rights (GRANT INSERT)
or a check/generate trigger from others

K
Konstantin Tsvetkov, 2019-03-06
@tsklab

Make this column calculated. It cannot be updated.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question