Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Auto increment field
In trying to move some test data from production to test I tried to use "append from production". I am using an autoincrement field for id and it doesn't like the "append from" saying it is read only.
I know I can scan the table and drop the values each field or can use SQL "insert into test(field1,field2) select field1,field2 from production) " but both require a listing of fields. Since this is a table with many many fields, is there a simplier way to move the data between tables with auto increment fields.
Thanks
Gaylen
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