mySQL check for column

Question

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?

Álvaro González · Accepted Answer · 2011-04-27 16:32:23Z

1

Good old SHOW COLUMNS FROM table_name:

http://dev.mysql.com/doc/refman/5.1/en/show-columns.html

answered Apr 27, 2011 at 16:32

Álvaro González

147k45 gold badges282 silver badges378 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

mySQL check for column

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related