Answers for "check column exists in table"

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'

Posted by: Guest on March-11-2021

Determine If a column is Present in a Table or not

if ($this->db->field_exists('field_name', 'table_name'))
{
        // some code...
}

Posted by: Guest on July-23-2021

Code answers related to "check column exists in table"