Interesting. Thanks guys!! On Wed, Aug 13, 2008 at 1:32 AM, Robin Vickery <robinv@xxxxxxxxx> wrote: > 2008/8/12 VamVan <vamseevan@xxxxxxxxx>: > > 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 > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >
