O
O
Oleg Seledets2019-02-19 20:24:49
JavaScript
Oleg Seledets, 2019-02-19 20:24:49

How to insert a record at the end of a table column and not a row?

Hello,
there is a table, for example 3 columns col1, col2, col3.
col1 - line 21
col2 - line 10
col3 - line 30
-------
It is required to add records separately, for example to col2. after some time in col3.
As a result:
col1 - 21 lines
col2 - 11 lines
col3 - 31 lines

Answer the question

In order to leave comments, you need to log in

2 answer(s)
L
lovegsxr, 2016-09-02
@lovegsxr

https://jsfiddle.net/e813o1cy/1/

D
d-stream, 2019-02-20
@d-stream

SQL operates on strings. Basically, that's the point.
The rest - dancing with insert | update
Well, or as an option for a sparse table:
(row_id, col_id, value), where pk: row_id, col_id

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question