I don't know if it's possible to count and add from each mysql table row.
this is what i have:
id: visits:
1 : 23 :
2 : 53 :
3 : 12 :
4 : 33 :
I want to count and add all visits from each rows, the total visits i should get is 121 visits.
if this make sense.
SELECT SUM(visits)as visitCounts FROM (
SELECT visits FROM tableName
) v
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments