Re: If Column Exists
| From: | Robin Vickery | Date: | Wed, 13 Aug 2008 08:32:59 +0000 |
| Subject: | Re: If Column Exists | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-278024@lists.php.net to get a copy of this message | ||
2008/8/12 VamVan <vamseevan@gmail.com>:
> Hello,
>
> I am working on data migration for one mysql db to another using PHP. How do
> I check if a particular table has a particular column. If not alter...
>
> Thanks
>
Use the information_schema:
SELECT COUNT(*) AS column_exists FROM information_schema.COLUMNS WHERE
TABLE_SCHEMA='db_name' AND TABLE_NAME='table_name' AND
COLUMN_NAME='column_name';
-robin