Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Quickest way to move data from one table to another
I am trying to find the fastest way to move data from one table to another. Both tables are almost Identical except the table recieving data has one extra field that has a default value which generate a unique id. Each table contain almost 85 fields or so but for simple example the following table fields have be reduced. Heres what I want to do:
table1 contains data that I want to move
field B
field C
field D
table2 is where I want to recieve the data from table A
field A
field B
field C
field D
how can I move table1 fields B thru D into table2 fields B thru D. In reality I have both table with approx 85 fields and I want to find a way of moving data maybe without defining every single field in table1 in the insert statement. Help appreciate
thank
nick patel
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement