Moving Some Fields Around?

[yarub]

How do I move fields with rows already in it? I'm combining to tables and the fields don't match up.

Table 1
A B [b]C D[/b] E F

Table 2
A B [b]D C[/b] E F

It basically looks like that. There are far too many rows to change each one individually. How can I just switch the two fields around?

[fenway]

I don't think you can actually do this without adding a new column in the right place, copying over the data, and then dropping the old column.  But why bother? You can combine two tables however you'd like.

[yarub]

How can I do that? I've been trying to do that, but it would appear I do not know how. I can't just drop the id column and add the other database to the the current one. The fields don't match up. So could you explain to me as to how I could o that?

[fenway]

That depends what you mean by "combine"...

[yarub]

Table 1
A B C D E F

Table 2
A B D C E F

I just want to take all of the rows from Table 2 and put them at the end of Table 1 via the auto increment thinger.

[fenway]

You can use "INSERT INTO t1 ( a, b, c, d, e, f ) SELECT a, b, c, d, e, f FROM t2"; how are you currently doing it?

[yarub]

How would that work though? The fields do not line up.

[fenway]

So?  You can SELECT fields in any order you choose, and INSERT fields in any order as well.

[yarub]

:o I did not know that.

[fenway]

Yup... SELECT takes a field list, however you want them back; and insert statement take a column list for that very reason as well.