php - Count non empty rows mysql

Question

php - Count non empty rows mysql

236

Accepted Answer

How to count non empty rows from 'naziv_operacije'? You can see table on the picture

Accepted Answer

Answer

Solution:

If the rows are empty strings or null, the below should do it:

SELECT COUNT(*)
FROM `TEHN`
WHERE `naziv_operacije` IS NOT NULL OR `naziv_operacije` != '';

Accepted Answer

Answer

Solution:

Try this:

select count(column_name) from naziv_operacije;

Replace column_name with the column which should not be empty

Accepted Answer

894

Answer

Solution:

The documentation of explains:

COUNT(expr)

Returns a count of the number of non-NULLvalues ofexprin the rows retrieved by aSELECTstatement. The result is aBIGINT` value.

COUNT(*) is somewhat different in that it returns a count of the number of rows retrieved, whether or not they containNULL values.

If by "empty" you meanNULL thenCOUNT(naziv_operacije) is all you need.
Run this query to see how it works:

SELECT 
    COUNT(naziv_operacije) AS not_empty,
    COUNT(*) AS all
FROM TEHN

Answer

Solution:

php - Count non empty rows mysql

Answer

Solution:

Answer

Solution:

Didn't find the answer?

Write quick answer

Similar questions