How do I count columns of a table

by 
SELECT count(*)
FROM information_schema.columns
WHERE table_name="tbl_ifo"

More Related Contents:

  1. get first occurrence of last changed value of a column [closed]
  2. SQL Print the name of all Employees together with the name of their supervisor
  3. MySQL – Rows to Columns
  4. ROW_NUMBER() in MySQL
  5. multiple query same table but in different columns mysql
  6. How can I temporarily disable a foreign key constraint in MySQL?
  7. How to do a batch insert in MySQL
  8. MySQL offset infinite rows
  9. Ordering by the order of values in a SQL IN() clause
  10. Creating a “Numbers Table” in MySQL
  11. SQL Selecting from two Tables with inner join and limit [duplicate]
  12. MySQL Group by SUM
  13. Get the latest date from grouped MySQL data
  14. In SQL, how to select the top 2 rows for each group
  15. Mysql query to dynamically convert rows to columns on the basis of two columns
  16. MySQL Error 1264: out of range value for column
  17. Special Characters in MySQL Table Name
  18. Is it possible to reference one column as multiple foreign keys?
  19. MySQL: How do I join same table multiple times?
  20. #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
  21. Split a string and loop through values in MySQL stored procedure
  22. How to create dummy variable columns for thousands of categories in Google BigQuery?
  23. Mysql: Order by like?
  24. Most efficient way to store IP Address in MySQL [duplicate]
  25. Getting first day of the week in MySql using Week No
  26. SQL date format convert? [dd.mm.yy to YYYY-MM-DD]
  27. mysql select id and name from other table and join query
  28. How do you force mysql LIKE to be case sensitive? [duplicate]
  29. #1060 – Duplicate column name ‘id’
  30. In what order are MySQL JOINs evaluated?

Leave a Comment