Change positive float to negative

[lonesoac0]

Hello all,

I have a CSV that has the values of:

Booking Date,Amount,Credit Debit Indicator,type,Type Group,Reference,Instructed Currency,Currency Exchange Rate,Instructed Amount,Description,Category,Check Serial Number,Card Ending
12/29/2023,0.01,Credit,Credit,Credit,,,,,Interest Income,Interest,,
12/29/2023,216.95,Debit,POS,POS,,,,,Prestige Tuxedo,Clothing/Shoes,,

My issue is that all of the values in the CSV are positive but they should be negative for the most part. If the transaction "Credit Debit Indicator" is Credit then leave positive. If "Credit Debit Indicator" is Debit, then change it to negative. How can I do that in MariaDB. The records are already present, I just need to update most of them.

Thank you.

[Nobbie]

UPDATE table_name
SET Amount = -Amount
WHERE `Credit Debit Indicator` = 'Debit';