MySQL query to get column names?

The best way is to use the INFORMATION_SCHEMA metadata virtual database. Specifically the INFORMATION_SCHEMA.COLUMNS table…

SELECT `COLUMN_NAME` 
FROM `INFORMATION_SCHEMA`.`COLUMNS` 
WHERE `TABLE_SCHEMA`='yourdatabasename' 
    AND `TABLE_NAME`='yourtablename';

It’s VERY powerful, and can give you TONS of information without need to parse text (Such as column type, whether the column is nullable, max column size, character set, etc)…

Oh, and it’s standard SQL (Whereas SHOW ... is a MySQL specific extension)…

For more information about the difference between SHOW... and using the INFORMATION_SCHEMA tables, check out the MySQL Documentation on INFORMATION_SCHEMA in general…

Related Posts:

  1. How to log in to phpMyAdmin with WAMP, what is the username and password?
  2. Should I use mysqli_real_escape string() or mysql_real_escape_string() for form data?
  3. Fatal error: Call to undefined function mysql_connect()
  4. PDOException SQLSTATE[HY000] [2002] No such file or directory
  5. http://localhost:80 is not working on running Apache server through UniServer ZeroXIII
  6. PDOException SQLSTATE[HY000] [2002] No such file or directory
  7. Mysql query- How to use contains?
  8. mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in
  9. Invalid column count in CSV input on line 1 Error
  10. Invalid column count in CSV input on line 1 Error
  11. $wpdb->update or $wpdb->insert results in slashes being added in front of quotes
  12. PDO with INSERT INTO through prepared statements
  13. phpMyAdmin: secret passphrase?
  14. PDO bindParam() with prepared statement isn’t working
  15. Forbidden :You don’t have permission to access /phpmyadmin on this server
  16. Creating a search form in PHP to search a database?
  17. How can I do ‘insert if not exists’ in MySQL?
  18. Fatal error: Call to a member function bind_param() on boolean [duplicate]
  19. MySqli Commands out of sync; you can’t run this command now
  20. Trying to get property of non-object in
  21. Fix Access denied for user ‘root’@’localhost’ for phpMyAdmin
  22. Getting connection failed: php_network_getaddresses: getaddrinfo failed: Name or service not known
  23. Commands out of sync; you can’t run this command now
  24. Lost connection to MySQL server at ‘reading initial communication packet’, system error: 0
  25. PHP with MySQL 8.0+ error: The server requested authentication method unknown to the client
  26. SQLSTATE[HY093]: Invalid parameter number: parameter was not defined
  27. How can I do ‘insert if not exists’ in MySQL?
  28. Object of class DateTime could not be converted to string
  29. What does it mean to escape a string?
  30. Convert from MySQL datetime to another format with PHP
  31. MAMP “Apache couldn’t be started because port is in use.” AND “Can’t connect to local MySQL server through /tmp/mysql.sock
  32. mysqli::query(): Couldn’t fetch mysqli
  33. Unexpected Exception: SQLSTATE[HY000] [1045] Access denied for user ****@’localhost’ (using password: YES)
  34. Uncaught Error: Call to undefined function mysql_escape_string()
  35. Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in
  36. Call to a member function on null?
  37. SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 102
  38. Warning: mysqli_query() expects parameter 1 to be mysqli, resource given
  39. What does MYSQLI_NUM mean and do?
  40. Mysql where id is in array
  41. ERROR: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it
  42. What is the advantage of using try {} catch {} versus if {} else {}
  43. select * from table where column = value ^ column2= value
  44. Deprecated: mysql_query() [duplicate]
  45. No query results for model [App\Products] Laravel
  46. Fatal error: Call to a member function query() on null
  47. mysqlworkbench giving version error on exporting database
  48. How to make DROP INDEX IF EXISTS for mysql?
  49. What is the meaning of sprintf(): Too few arguments
  50. Having a problem getting mysqli_query to execute
  51. CodeIgniter: Unable to connect to your database server using the provided settings Error Message
  52. Can I store images in MySQL 
  53. MySQL Daemon Failed to Start – centos 6
  54. How to insert TIMESTAMP into my MySQL table?
  55. How to remove index.php from WordPress site URL
  56. PHP Like thing similar to MySQL Like, for if statement?
  57. How get value from URL
  58. How to use Memcached with PHP7?
  59. select count(*) from table of mysql in php
  60. 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 ””)’ at line 2
  61. Replace ' and similar html codes with their correspondent character?
  62. Google Calendar API event update always return 404 “not found” error
  63. How to prevent the “Confirm Form Resubmission” dialog?
  64. navigate back with PHP form submission
  65. How to set 777 permission on a particular folder? [closed]
  66. How do I make a redirect in PHP?
  67. How to use mysqli_query() in PHP?
  68. List of All Locales and Their Short Codes?
  69. Difference between “as $key => $value” and “as $value” in PHP foreach
  70. How do I get a YouTube video thumbnail from the YouTube API?
  71. What is a slug?
  72. Visual list of all installed fonts with respective pangram phrase?
  73. How to avoid Request Entity Too Large 413 error
  74. Array to String PHP?
  75. Undefined function mysql_connect()
  76. MySQL column count doesn’t match value count at row 1 [closed]
  77. Undefined function mysql_connect()
  78. Fatal error: Call to undefined function mysql_connect()
  79. count() parameter must be an array or an object that implements countable in laravel
  80. regex match any whitespace
  81. What’s the net::ERR_HTTP2_PROTOCOL_ERROR about?
  82. How to fix “Headers already sent” error in PHP
  83. currently unable to handle this request HTTP ERROR 500
  84. PHP page redirect
  85. Fatal error: Call to undefined function mysql_connect()
  86. Whoops, looks like something went wrong. Laravel 5.0
  87. PHP “or” Syntax
  88. How to fix “Headers already sent” error in PHP
  89. “Notice: Undefined variable”, “Notice: Undefined index”, and “Notice: Undefined offset” using PHP
  90. What are namespaces?
  91. Get the full URL in PHP
  92. How do I get PHP errors to display?
  93. S_SESSION variable (user role) not recognised
  94. What are the main differences between PHPExcel and PhpSpreadsheet?
  95. Is SAJAX dead? What to replace with?
  96. How do I resolve a HTTP 414 “Request URI too long” error?
  97. Get the full URL in PHP
  98. How do I check if a string contains a specific word?
  99. PDOException: SQLSTATE[HY000] [2002] No such file or directory
  100. xajax expanding list query

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)