Column Count in MySQL

Posted on August 31, 2007, under MySQL.

I was looking for a way to count the column in a table and found this code:

SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='mls_listings';

-Pads

Leave a Comment

You must be logged in to post a comment.