LogoShubo Zhang
    Logo Inverted Logo
    • Posts
    • AWS
      • dynamodb-acid
      • dynamodb-admin
      • S3-log
    • DB
      • How to Use MySQL count
    • micronaut
      • mn-graalvm
    • Software Design and Engineering
      • Clean Code
        • 01-Meaningful Names
    • Tools
      • mac-itsycal
      • mac-stats
      • mac-world-time
      • owasp-1-sql-injection
      • owasp-2-broken-authentication
      • owasp-3-sensitive-data-exposure
      • owasp-4-XML-External-Entities (XXE)
      • Postgres 12 + pgadmin in Docker
    Hero Image
    How to Use MySQL count

    How many ways to use count? count(*): returns a count of the number of all rows (including NULL). count(1): 1 evaludates to non-NULL for every row, so it returns the same results as count(*) count(col_name): returns a count of the number of the rows that col_name is not NULL count(col_name) VS count(*)? count(*): returns a count of the number of all rows (including NULL). count(col_name): returns a count of the number of the rows that col_name is not NULL count(*) is recommended even though count(pk) can return the same result.

    December 20, 2020 Read
    Navigation
    • About Me
    • Skills
    • Experiences
    • Projects
    • Recent Posts
    • Achievements
    Contact me:
    • Email: shubozhang@outlook.com
    • Phone: +0123456789

    Stay up to date with email notification

    We'll never share your email with anyone else.

    Toha Theme Logo Toha
    © 2020 Copyright.
    Powered by Hugo Logo