← Back to team overview

maria-discuss team mailing list archive

New Question: Table and Column



A new question has been asked in "MariaDB Community" by Redman Companies. Please answer it at http://mariadb.com/kb/en/table-and-column/ as the person asking the question may not be subscribed to the mailing list.

I have created a new table called 'B' using a table called 'A'. My question is, how do I create three new columns in table B and populate them with data from table A? Your help would be greatly appreciated. Thank you in advance. (See example below)

Ex.tables---      A                                                            ------------                      B
columns          a,  a1,  a2...   b , b1,  b2...   c,  c1,  c2...                                       x,     y,      z,  
                                                                                                                            a      b      c
                                                                                                                            a1    b1    c1 
                                                                                                                            a2    b2    c2
                                                                                                                            .       .       .
                                                                                                                            a8    b8     c8
Put all of the data from a...a8 into column x line by line
Put all of the data from b..b8. into column y line by line
Put all of the data from c...c8 into column z line by line

To view or answer this question please visit: http://mariadb.com/kb/en/table-and-column/