title: MySQL query to get count of column name from a table of a database?
body: <p>Can anybody please convert this SQL query to mysql syntax:-</p>
  
  <pre><code>SELECT Count(COLUMN_NAME)
  FROM DataBaseName.INFORMATION_SCHEMA.COLUMNS
  WHERE TABLE_NAME = N'TableName';
  </code></pre>
  
  <p>This is the SQL query to get no of records in a column of a table in a database.</p>
  
  <p>I want the MySQL syntax of above query.</p>
  
  <p>Thanks in advance.</p>