mysql syntax error in update with same table

Question

The error showing

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near

i think an error in the syntax

update invoice AS t1, 

(select sum(total_cost) from invoice where billno='X-0125' and item='11') AS t2 

set t1.total_cost=(t1.total_cost/(t2.sum(total_cost))*100
                
WHERE t1.billno='X-0125' and t1.item='11'

set t1.total_cost=(t1.total_cost/(t2.sum(total_cost))*100 I Think you miss ) — user5039044
– user5039044, Commented Jun 7, 2018 at 8:05

Chris · Accepted Answer · 2018-06-07 08:06:33Z

1

Missing one paranthesis after '100' for example (depends on what you want) but missing one:

update
  invoice AS t1,
  (
    select
      sum(total_cost)
    from
      invoice
    where
      billno = 'X-0125'
      and item = '11'
  ) AS t2
set
  t1.total_cost =(t1.total_cost /(t2.sum(total_cost)) * 100)
WHERE
  t1.billno = 'X-0125'
  and t1.item = '11'

answered Jun 7, 2018 at 8:06

Chris

2341 gold badge3 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

mysql syntax error in update with same table

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related