Auto insert col names without specifying col names

Databases
1

table test1 has cols f1, f2
table test2 has cols f1, f2, f3
INSERT INTO test2 (f1,f2) SELECT * FROM test1
successfully INSERTS test2 with the data in test1

Can that be done with out specifying column names?
I think its called auto mapping.

2

no

1 Like
3

OK.

I could’ve sworn that there was a way to get the col names, in the source table, to auto match the col names, in the targeted table, without listing them individually.

Thanks for help r937. You saved me from a pointless quest.

1 Like
4

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.