<div>
tried this instead?<br />
<br />

<pre><code id="code-20-42754141-1">SELECT COUNT(tblClients.cli_Name) FROM tblClients</code></pre>
<br />
without space after &quot;COUNT&quot;.
</div>


tried this instead?



SELECT COUNT(tblClients.cli_Name) FROM tblClients


without space after "COUNT".

EE Topic Advisor

PortletPaul

Alexandre Takacs

Ryan Chong

<div>
that's it - I muss confess I could not work it out so big thanks !
</div>


that's it - I muss confess I could not work it out so big thanks !

<div>
<div class="content wysiwyg-content">
ok this seems pretty basic...<br />
<br />
Why does<br />
<br />

<pre><code id="code-10-29129180-1">SELECT COUNT (tblClients.cli_Name) FROM tblClients</code></pre>
<br />
returns error<br />
<br />

<pre><code id="code-10-29129180-2">* SQL Error (1630): FUNCTION myDB.COUNT does not exist. Check the 'Function Name Parsing and Resolution' section in the Reference Manual */
/* Affected rows: 0  Found rows: 0  Warnings: 0  Duration for 0 of 1 query: 0.000 sec. */</code></pre>
<br />
in mySQL 8.0<br />
<br />
seems like a correct syntax to me ?
</div>
</div>


ok this seems pretty basic...

Why does

(CODE)

returns error

(CODE)

in mySQL 8.0

seems like a correct syntax to me ?

mySQL SELECT COUNT query ?

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.