Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

sql check if column exists

* Using the below query, You can check whether the table1 has a column named "id"

SHOW COLUMNS FROM table1 LIKE 'id'
Source by stackoverflow.com #
 
PREVIOUS NEXT
Tagged: #sql #check #column #exists
ADD COMMENT
Topic
Name
2+6 =