Computers and Technology, 05.07.2021 15:20, arielcainess

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.

Answers: 2

Show answers

Other questions on the subject: Computers and Technology

Computers and Technology, 21.06.2019 19:20, khenalilovespandas

Number of megabytes of ram in a computer. qualitative or quantitative? because

Answers: 3

continue

Computers and Technology, 22.06.2019 11:30, genyjoannerubiera

What does a cascading style sheet resolve a conflict over rules for an element? a. the rule affecting the most content wins b. the rule affecting the most content loses c. the rule with the most specific selector loses d. the rule with the most specific selector wins

Answers: 2

continue

Computers and Technology, 22.06.2019 20:00, jumpgirll

The blank button automatically displays next to the data when you select a range of numeric data which is an available option for creating a chart

Answers: 3

continue

Computers and Technology, 23.06.2019 23:00, GreenHerbz206

Computer programming is one type of what career

Answers: 1

continue

Do you know the correct answer?

Write an UPDATE statement that modifies the invoice you added in exercise 4. This statement should c...