subject

Write an UPDATE statement that modifies the invoice you added in exercise 4. This statement should change the credit_total column so it's 10% of the invoice_total column, and it should change the payment_total column so the sum of the payment_total and credit_total columns are equal to the invoice_total column UPDATE invoices

SET credit_total = invoice_total * 0.1, payment_total = invoice_total - credit_total

WHERE invoice_id = 115

every time I run this query, I get this error:

1265 Data truncated for column 'credit_total' at row 1 Rows.

ansver
Answers: 1

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 23:30
What is the digital revolution and how did it change society? what are the benefits of digital media?
Answers: 1
question
Computers and Technology, 23.06.2019 20:30
If an appliance consumes 500 w of power and is left on for 5 hours, how much energy is used over this time period? a. 2.5 kwh b. 25 kwh c. 250 kwh d. 2500 kwh
Answers: 1
question
Computers and Technology, 24.06.2019 14:00
When creating a field in a table, you must set the to determine what type of data the field can store. field property data type field type data property
Answers: 1
question
Computers and Technology, 24.06.2019 22:00
Ican’t open these when it’s just a comment. someone pls explain why this is happening
Answers: 1
You know the right answer?
Write an UPDATE statement that modifies the invoice you added in exercise 4. This statement should c...
Questions
question
Mathematics, 20.05.2021 01:50
question
Mathematics, 20.05.2021 01:50
question
Mathematics, 20.05.2021 01:50