funbinod Posted April 12, 2014 Share Posted April 12, 2014 (edited) can mysql table hold a STRING not a exact value? like [ ($ob + $totalSales) - $totalReceipt ] and how can we SUM total value from selected rows? Edited April 12, 2014 by funbinod Link to comment Share on other sites More sharing options...
justsomeguy Posted April 14, 2014 Share Posted April 14, 2014 MySQL has data types like varchar, char, text, longtext, etc to hold strings of various sizes. There are functions like COUNT and SUM that work over a result set, called aggregate functions.http://dev.mysql.com/doc/refman/5.6/en/string-types.htmlhttps://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now