seniors, I want to splice the existing fields and fill them in the new fields, such as
original table

< table > < thead > < tr > < th > id < / th > < th > name < / th > < th > date < / th > < th > record_id < / th > < / tr > < / thead > < tbody > < tr > < td > 1 < / td > < td > A < / td > < td > 20180101 < / td > < td > null < / td > < / tr > < tr > < td > 2 < / td > < td > B < / td > < td > 20180102 < / td > < td > null < / td > < / tr > < tr > < td > 3 < / td > < td > C < / td > < td > 20180103 < / td > < td > null < / td > < / tr > < / tbody > < / table >

Update table:

< table > < thead > < tr > < th > id < / th > < th > name < / th > < th > date < / th > < th > record_id < / th > < / tr > < / thead > < tbody > < tr > < td > 1 < / td > < td > A < / td > < td > 20180101 < / td > < td > Amur20180101-001 < / td > < / tr > < tr > < td > 2 < / td > < td > B < / td > < td > 20180102 < / td > < td > BMI 20180102-002 < / td > < / tr > < tr > < td > 3 < / td > < td > C < / td > < td > 20180103 < / td > < td > Cmur20180103-003 < / td > < / tr > < / tbody > < / table >

where id is the self-incrementing primary key. The goal is to concatenate the name-date-id into the new field record_id.
at the same time, enter new name and date each time. For example, insert name="D", date="20180104", to get
4 | D | 20180104 | Dmai 20180104004

ask for advice, thank you.