Comments - Table and Column
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
how do I create three new columns in table B
alter-table
and populate them with data from table A?
INSERT ... SELECT... FROM A
Thank you very much I will work on it. I will let you know how I do. Thanks again.
Did I mention I am new to this??? lol I would appreciate it if you would help. Thank you. CREATE TABLE B AS ( SELECT col_a, col_b, col_c, col_ etc.... INSERT SELECT col_u1, col_u2, col_u3, col_u4, col_u5, col_u6, col_u7, col_u8, INTO colu_New INSERT SELECT col_ud1, col_ud2, col_ud3, col_ud4, col_ud5, col_ud6, col_ud7, col_ud8 INTO colud_New INSERT SELECT col_uc1, col_uc2, col_uc3, col_uc4, col_uc5, col_uc6, col_uc7, col_uc8 INTO coluc_New INSERT SELECT FROM A);