mysql, iterate through column names

by

I think you want something like this:

DECLARE col_names CURSOR FOR
  SELECT column_name
  FROM INFORMATION_SCHEMA.COLUMNS
  WHERE table_name="tbl_name"
  ORDER BY ordinal_position;


select FOUND_ROWS() into num_rows;

SET i = 1;
the_loop: LOOP

   IF i > num_rows THEN
        CLOSE col_names;
        LEAVE the_loop;
    END IF;


    FETCH col_names 
    INTO col_name;     

     //do whatever else you need to do with the col name

    SET i = i + 1;  
END LOOP the_loop;

More Related Contents:

  1. MySQL: Alternatives to ORDER BY RAND()
  2. MySQL LIKE IN()?
  3. Auto Increment after delete in MySQL
  4. Unioning two tables with different number of columns
  5. NULL in MySQL (Performance & Storage)
  6. In MySQL queries, why use join instead of where?
  7. MySQL function to find the number of working days between two dates
  8. MySQL Trigger to prevent INSERT under certain conditions
  9. Importance of varchar length in MySQL table
  10. Stored Procedure with optional “WHERE” parameters
  11. mySQL :: insert into table, data from another table?
  12. Return 0 if field is null in MySQL
  13. SQLite – ORDER BY RAND()
  14. How to search multiple columns in MySQL?
  15. How to delete from select in MySQL?
  16. How to ORDER BY a SUM() in MySQL?
  17. mySQL Returning the top 5 of each category
  18. SQL SELECT to get the first N positive integers
  19. Sorting string column containing numbers in SQL?
  20. Multiple Ranks in one table
  21. Create date from day, month, year fields in MySQL
  22. The difference between ‘AND’ and ‘&&’ in SQL
  23. Can I use a MySQL database with an App Engine application
  24. How can I make an average of dates in MySQL?
  25. What is the best way to generate ranks in MYSQL?
  26. What does collation mean?
  27. What’s the correct name for an “association table” (a many-to-many relationship) [closed]
  28. sql pulling a row for next or previous row of a current row
  29. Row Rank in a MySQL View
  30. Select Rows with Maximum Column Value group by Another Column

Leave a Comment