MySQL, Check if a column exists in a table with SQL

by

This works well for me.

SHOW COLUMNS FROM `table` LIKE 'fieldname';

With PHP it would be something like…

$result = mysql_query("SHOW COLUMNS FROM `table` LIKE 'fieldname'");
$exists = (mysql_num_rows($result))?TRUE:FALSE;

More Related Contents:

  1. Delete the entire content of all table in a Database [closed]
  2. MyISAM versus InnoDB [closed]
  3. Calculate a running total in MySQL
  4. How do I find the MySQL my.cnf location
  5. How to change MySQL data directory?
  6. MySQL Syntax error message “Operand should contain 1 column(s)”
  7. GROUP_CONCAT ORDER BY
  8. MySQL: ALTER TABLE if column not exists
  9. MySQL SELECT increment counter
  10. Prevent auto increment on MySQL duplicate insert
  11. Query from two tables in report
  12. MySQL – force not to use cache for testing speed of query
  13. Is it safe to store usernames and passwords in the database?
  14. How do I know when my docker mysql container is up and mysql is ready for taking queries?
  15. How to count all rows when using SELECT with LIMIT in MySQL query?
  16. MySQL FULL JOIN?
  17. How to fix double-encoded UTF8 characters (in an utf-8 table)
  18. How to integrate ElasticSearch with MySQL?
  19. MySQL INSERT INTO … VALUES and SELECT
  20. MySQL LOAD_FILE() loads null values
  21. What are practical differences between `REPLACE` and `INSERT … ON DUPLICATE KEY UPDATE` in MySQL?
  22. MySQL Select ID’s which occur on different rows with multiple specific values for a column
  23. How to compare timestamp dates with date-only parameter in MySQL?
  24. How to sort a MYSQL table in a permanent way?
  25. UPDATE with ORDER BY and LIMIT not working in MYSQL
  26. Equivalent of MSSQL IDENTITY Column in MySQL
  27. #1060 – Duplicate column name ‘id’
  28. Update multiple rows with multiple ‘where’ clauses for each individual row
  29. WHERE datetime older than some time (eg. 15 minutes)
  30. Is there a way to use ON DUPLICATE KEY to Update all that I wanted to insert?

Leave a Comment