mardi 4 août 2015

Python/SQL: move column in table A to table B

I have connected to a sql database through python using sql alchemy. I have a table called A and another table called B. The data from A and B comes from table F.

         **A**                         **B**
C1  C2  C3  C4  C5             D1    D2    D3   D4   D5

I was wondering if it is possible to take column C5 and insert it into table B such that table B looks like:

       **B**
D1  D2  D3  D4  D5  C5

I haven't come across any direct methods to do this. Has anyone figured out a way to approach this?



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire