Get table column names in MySQL?

by

You can use DESCRIBE:

DESCRIBE my_table;

Or in newer versions you can use INFORMATION_SCHEMA:

SELECT COLUMN_NAME
  FROM INFORMATION_SCHEMA.COLUMNS
  WHERE TABLE_SCHEMA = 'my_database' AND TABLE_NAME = 'my_table';

Or you can use SHOW COLUMNS:

SHOW COLUMNS FROM my_table;

Or to get column names with comma in a line:

SELECT group_concat(COLUMN_NAME)
  FROM INFORMATION_SCHEMA.COLUMNS
  WHERE TABLE_SCHEMA = 'my_database' AND TABLE_NAME = 'my_table';

More Related Contents:

  1. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘WHERE `id` [closed]
  2. How can create Database using url or other method [duplicate]
  3. Problame with files on SQL
  4. Im trying to create some temporary tables in mysql using php
  5. How can I prevent SQL injection in PHP?
  6. SQL injection that gets around mysql_real_escape_string()
  7. How to include a PHP variable inside a MySQL statement
  8. How to apply bindValue method in LIMIT clause?
  9. SELECT COUNT(*) AS count – How to use this count
  10. How to resolve ambiguous column names when retrieving results?
  11. selecting unique values from a column
  12. Use bound parameter multiple times
  13. I cannot get my login form to connect interact properly with mySQL database [closed]
  14. mysql_num_rows(): supplied argument is not a valid MySQL result resource [duplicate]
  15. Increment value in MySQL update query
  16. Create a dynamic mysql query using php variables
  17. How to separate DATE and TIME from DATETIME in MySQL?
  18. Do SQL connections opened with PDO in PHP have to be closed
  19. How to convert ISO8601 to Date format in php
  20. MySQL skipping first row
  21. How to reverse order output of a MySQL query
  22. How to generate unique id in MySQL?
  23. Fatal error: Call to a member function query() on null
  24. How would I implement a simple site search with php and mySQL?
  25. How to check if a value already exists to avoid duplicates?
  26. UNION syntax in Cakephp
  27. MYSQL select a piece of a string and order by that piece
  28. How do i search from serialize field in mysql database?
  29. PHP/MySQL Pagination
  30. Limit pagination page number

Leave a Comment