Computers and Technology, 30.07.2021 01:20, dbzrules02

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 this is my query:
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. i need help in solving this error.

Answers: 3

Show answers

Other questions on the subject: Computers and Technology

Computers and Technology, 23.06.2019 04:31, tbt81

Type the correct answer in the box. spell all words correctly. the managing director of a company sends a christmas greeting to all his employees through the company email. which type of network does he use? he uses an

Answers: 1

continue

Computers and Technology, 23.06.2019 06:20, kiarakagni

What is a point-in-time measurement of system performance?

Answers: 3

continue

Computers and Technology, 23.06.2019 10:50, whyidkmyself

Your friend kayla is starting her own business and asks you whether she should set it up as a p2p network or as a client-server network. list three questions you might ask to kayla decide which network to use and how her answers to those questions would affect your recommendation.

Answers: 2

continue

Computers and Technology, 24.06.2019 17:40, finedock

Anewly established internet company with 40 employees needs your advice. they are looking for a collaboration tool and have narrowed their choices to gotomeeting, webex, and my web conferences. after reading the information presented in this chapter and other sources, prepare a two- page document ( double spaced) that includes two advantages and two disadvantages of each tool. which one is your final recommendation? why did you choose that tool over the other two?

Answers: 3

continue

Do you know the correct answer?

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