Use of single quotes in select query while aggregating data?

What is the difference between

  1. select avg('orders') and
  2. select avg(orders) in MySQL?

Also, are both correct in syntax?

If yes, when do you use each of them?

Answers


The AVG() function returns the average value of a numeric column.

 avg('orders')  always return 0 because avg of string ('orders') is zero

Or

Avg(orders) return average of column orders

correct syntax

Avg(`orders`) or Avg(orders) are correct syntax

Need Your Help

Remove white and unnecessary space from Chart control

c# winforms charts whitespace

I have a chart and I've added it to a panel but as you can see in the picture, the chart does not fill the whole panel. it has a lot of white space that I highlighted in red.