Deleting rows from a table

[hunterfan48]

Hello,
I have a table I created for keeping track of the transactions within my business. Up until recently, I would enter the shipping costs of something I sold as a new record (row) in my transactions table. I realized it would be much easier to simply create a 'shipiping costs' field within my transactions table to record the shipping cost for each specific transaction. I no longer need to enter a new row for just shipping costs of a transaction...I put that with that specific transaction within its new field.

I have transferred over these amounts into these fields for the proper transactions to make sure they have been accounted for. Is it safe to go ahead and delete the shipping costs records within my table??

Thanks,

 

[John Big Booty]

Try doing it on a Copy of your data first, so you can make sure there are no unintended consequences to deleting that data.

 

[hunterfan48]

Thank you kind sir...are there any off the top of your head in your own experience that you can think of that would be unintended consequences?

 

[John Big Booty]

No. I was thinking more along the lines of you deleting something, from your DB, that you latter found had a consequence you hadn't foreseen. It's always a concern when you make structural changes to a DB.

 

[hunterfan48]

Well, since I now have added a field to this table to account for shipping costs, if I put the cost (let's say $1.75 for example) into the column shipping costs for transaction #0050 and then put another record in (that being transaction #0051 to account for the shipping costs of transaction #0050) well that's just plain silly cause I'm actually accounting for this twice right?