All Forums Database
realrx7 17 posts Joined 06/12
22 Aug 2012
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.

ulrich 816 posts Joined 09/09
22 Aug 2012

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

feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud

realrx7 17 posts Joined 06/12
22 Aug 2012

Thanks for the clarification.

You must sign in to leave a comment.