Computers and Technology, 20.06.2020 17:57, savvaggeb

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: 3

Show answers

Other questions on the subject: Computers and Technology

Computers and Technology, 22.06.2019 19:20, sindy35111

Terri needs to insert a cover page into her document. where should she go to access the commands to do so? o insert tab, objects group o insert tab, illustrations group o insert tab, pages group o insert tab, media group submit

Answers: 1

continue

Computers and Technology, 23.06.2019 09:10, babyskitt

Effective character encoding requires standardized code. compatible browsers. common languages. identical operating systems.

Answers: 1

continue

Computers and Technology, 23.06.2019 13:10, BrianKeokot4534

What is domain name system (dns)? allows dynamic ip address allocation so users do not have to have a preconfigured ip address to use the network converts ip addresses into domains, or identifying labels that use a variety of recognizable naming conventions the efficient coexistence of telephone, video, and data communication within a single network, offering convenience and flexibility not possible with separate infrastructures the integration of communication channels into a single service

Answers: 2

continue

Computers and Technology, 23.06.2019 14:30, naomi20044

Select the correct answer. andy received a potentially infected email that was advertising products. andy is at risk of which type of security threat? a. spoofing b. sniffing c. spamming d. phishing e. typo-squatting

Answers: 2

continue

Do you know the correct answer?

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