Member Avatar for mpc123

Hi

I need to update a colomn with the result of colomn 1 divided colomn2

I have tried

update TABLE set colomn =SUM(colomn1 / colomn2)

but get [Err] 1111 - Invalid use of group function

IF anyone can help please

  • 1 Contributor
  • 1 Reply
  • 131 Views
  • 4 Minutes Discussion Span
  • Latest Post Latest Post by mpc123
Member Avatar for mpc123

sorry i have now managed to make it work by just taking out the word SUM

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.