Total count of a table data in mysql without using COUNT
Count of total data with out using Count function select sum(1) as count from tablename; Count of total data using Count function select count(*) from tablename;
Tag Archives: sum function in mysql
SUM function in Mysql
This function used to find the sum of fields in various records See the example below Select * from mydoubts_data ————————————- |id | jobid | name | salary | age| ————————————- |1 | 121 | vasanthan| 2000 |32 | |2 | 122 | John | 3000 |28 | |3 | 123 | Kiran | 3400… Read More »