Jump to content
xisto Community

suicide1405241470

Members
  • Content Count

    55
  • Joined

  • Last visited


Reputation Activity

  1. Upvote
    suicide1405241470 got a reaction from XRumerTest in Empty vs Null   
    I exported an Access database to csv file, and then imported the csv file to mysql.Now I'm trying to use COUNT() on a field, but its returning the total number of records, which is not what I want. I know that COUNT() is supposed to count all records that arent Null, so I checked out my table in phpmyadmin and I realized that even though there are no values for some records they are not showing up as Null.What is the difference between a Null and a field that is just empty? Shouldn't it be the same? Is there a way to count the records, or do I need to change those values to Null?
×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.