U
U
uuuu2020-05-30 03:00:50
MySQL
uuuu, 2020-05-30 03:00:50

How to create automatic field completion in MySQL?

For example, there is a table:

model | color | x | y | z

And the second table:

model | x | y

We can say that the first table contains all the data, but the second requires only X and Y. How to make XY auto-complete when adding a model (exactly the same as in the first table).

Answer the question

In order to leave comments, you need to log in

3 answer(s)
T
ThunderCat, 2020-05-30
@ThunderCat

trigger

G
galaxy, 2020-05-30
@galaxy

Trigger ?

L
Lazy @BojackHorseman MySQL, 2020-05-30
Tag

and what for to duplicate the data in the second table?

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question