Insert data into table with data imported already

Database
Enthusiast

Insert data into table with data imported already

So this is probably a dumb question, but if I have a table that I have already imported data into, and I want to insert more data, will the previous data be overwritten? I want to import another file with the same data types, but I just want the data to be appended to the table.

Tags (1)
2 REPLIES
Supporter

Re: Insert data into table with data imported already

so, why don't you try it?

Read the SQL basisc

inserts will add rows

Update will modify rows

and Delete will delete rows.

There exists exceptions for Insert for example SET vs. MULTISET and UPI and USI constrains so try it and read the manuals

Enthusiast

Re: Insert data into table with data imported already

Thanks for the clarification.