Is it possible to know whether a particular table field exista in a table or not?
Secondly is it possible to display all the table fields existing in the table.
I have a table called articles inside a database named mysql
I want to display all the table fields present in articles or check whether a particular field exists. How to do?
Table field exists?
Moderator: General Moderators
- seppo0010
- Forum Commoner
- Posts: 47
- Joined: Wed Oct 24, 2007 4:13 pm
- Location: Buenos Aires, Argentina
Code: Select all
SHOW COLUMNS IN `table`Code: Select all
SHOW COLUMNS IN `table` LIKE 'fieldname';http://dev.mysql.com/doc/refman/5.0/en/ ... lumns.html