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, 21.06.2019 15:10, reyescarlosivan0

Match the terms in the hlookup syntax with their explanation. a. lookup value b. data table c. row index d. mode 1. name of the table that contains the value 2. specifies if an exact match must be found 3. value to be searched 4. name of the row that contains the value

Answers: 1

continue

Computers and Technology, 22.06.2019 06:30, messyquestions

Plz 40 points what are raster vectors? a bitmap image a vector file a type of printing press a small projector

Answers: 1

continue

Computers and Technology, 22.06.2019 15:10, AleciaCassidy

Consider a direct-mapped cache with 216 words in main memory. the cache has 16 blocks of 8 words each. it is a word-addressable computer (rather than a byte-addressable computer which we normally discuss). (a) how many blocks of main memory are there? (b) what is the format of a memory address as seen by the cache, that is, what are the sizes of the tag, cache block, and block offset fields (if they apply)? (c) to which cache block will the memory reference db6316 map?

Answers: 1

continue

Computers and Technology, 23.06.2019 03:50, dondre54

Q-1 which of the following can exist as cloud-based it resources? a. physical serverb. virtual serverc. software programd. network device

Answers: 1

continue

You know the right answer?

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