Find the number of columns in a table

by 
SELECT COUNT(*)
  FROM INFORMATION_SCHEMA.COLUMNS
 WHERE table_catalog = 'database_name' -- the database
   AND table_name="table_name"

More Related Contents:

  1. How can I do a FULL OUTER JOIN in MySQL?
  2. You can’t specify target table for update in FROM clause
  3. How do I see what character set a MySQL database / table / column is?
  4. Generating a range of numbers in MySQL
  5. How to get next/previous record in MySQL?
  6. How do I make a row generator in MySQL?
  7. MySQL INSERT INTO table VALUES.. vs INSERT INTO table SET
  8. MySQL number of items within “in clause”
  9. Error 1046 No database Selected, how to resolve?
  10. What’s the difference between VARCHAR and CHAR?
  11. Alter a MySQL column to be AUTO_INCREMENT
  12. Is there something wrong with joins that don’t use the JOIN keyword in SQL or MySQL?
  13. MySQL ON DUPLICATE KEY UPDATE for multiple rows insert in single query
  14. single fixed table with multiple columns vs flexible abstract tables
  15. MySQL remove duplicates from big database quick
  16. mysql, iterate through column names
  17. How to delete from select in MySQL?
  18. How to delete Duplicates in MySQL table
  19. How to ORDER BY a SUM() in MySQL?
  20. mySQL Returning the top 5 of each category
  21. Selecting Random Rows in MySQL
  22. Is it possible to have an indexed view in MySQL?
  23. Error: The used SELECT statements have a different number of columns
  24. How to Optimize Queries in a Database – The Basics
  25. Mysql, reshape data from long / tall to wide
  26. MySQL: Compare differences between two tables
  27. Mysql strip time component from datetime
  28. How do I start auto increment from a specific point?
  29. In SQL how do I get the maximum value for an integer?
  30. Get the first and last date of next month in MySQL

Leave a Comment