Categories
Database Development

Update large number of row in MySQL table

I’m using relational database(MySQL 5.7). On this database i have a table called customer_transaction. On this table i have 4 columns: id, customer_id, type, amount |id|customer_id |type |amount| |–|————|———|——| |1 |44 |Credit |50 | |2 |44 |Credit |20 | |3 |44 |Debit |30 | |4 |10 |Credit |30 | now i am introduce a new […]