Comments - Table and Column

5 years, 1 month ago Daniel Black

how do I create three new columns in table B

alter-table

and populate them with data from table A?

INSERT ... SELECT... FROM A

 
5 years, 1 month ago Rick -

Thank you very much I will work on it. I will let you know how I do. Thanks again.

 
5 years, 1 month ago Rick -

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);

 
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.