julio
Reputation: 6728
mySQL check for column
I know how to check for the existence of a column using the syntax
SELECT * FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = "my_table" AND COLUMN_NAME = "my_column"
Is there a way to check for the existence of a column when the DB user doesn't have access to the information_schema? Or would you just do something like try a SELECT from that column and if you get an error then you know that the column doesn't exist?
Upvotes: 1
Views: 78
Answers (1)
Related Questions
- Check if a column exists in a table with MySQL
- SQL If one column has a desired value then check the next column
- How to check column exist or not before select that column from table
- Mysql check if a value exists in which column
- How do I check whether column exists in the table?
- How to check condition in a query.
- MySQL conditional check
- checking field in my sql
- Check a certain data from a column
- Testing for existence of a column