Learning Curve- Perfect Tutorial for the beginers
Follow us on Twitter Follow us on Facebook Follow us on Google Plus Follow us on rss
Skip to content
  • Home
  • APS1.0
  • APS2.0
  • PHP
  • SQ L& MYsql
  • Linux Shell Scripting
  • Codeigniter
  • Technical questions
  • Laravel
  • Angularjs
  • Node js
  • English Corner

Total count of a table data in mysql without using COUNT

By Admin | June 19, 2014
0 Comment

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;

Category: SQ L& MYsql Tags: count() function in mysql, sum function in mysql, total count of mysql table data without using count function
Post navigation
← Supported range of DATE,DATETIME,TIMESTAMP in mysql Do we need to add type=”text/javascript” inside the

Recent Posts

  • Word Power
  • Startup applications not working in windows10 after changing the passoword
  • How to Create component and services in angularjs
  • Angularjs error:has been blocked by CORS policy: Response to preflight request doesn’t pass access control check: No ‘Access-Control-Allow-Origin’ header is present on the requested resource
  • php artisan –version not working in laravel it throws error-In UrlGenerator.php line 111: Argument 2 passed to Illuminate\Routing\UrlGenerator::__construct() must be an instance of Illuminate\Http\Request, null given, called in

Recent Comments

  • Vasanthan pv on Force Download in laravel-file download in laravel
  • Trey Mhundwa on Force Download in laravel-file download in laravel
  • Vasanthan pv on Link not working in codeigniter, base_url() displaying “”http://::1” why?
  • adil on Link not working in codeigniter, base_url() displaying “”http://::1” why?
  • Brook on composer update issues in laravel

Archives

Categories

Tweets about mydoubtsin
Follow @mydoubtsin
web
statistics
Copyright 2016
mydoubts.in
Iconic One Theme | Powered by Wordpress