Re: [PHP] If Column Exists

2008-08-17 Thread Luke
There is IF EXISTS for tables, is there the same thing for columns in the table like IF EXISTS column IN TABLE table ? Just an idea 2008/8/13 VamVan [EMAIL PROTECTED] Interesting. Thanks guys!! On Wed, Aug 13, 2008 at 1:32 AM, Robin Vickery [EMAIL PROTECTED] wrote: 2008/8/12 VamVan

RE: [PHP] If Column Exists

2008-08-13 Thread Per Jessen
Jay Blanchard wrote: [snip] 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... [/snip] Use DESCRIBE TABLE; Then you'd have to parse the output - how about SELECT column FROM table LIMIT 1

Re: [PHP] If Column Exists

2008-08-13 Thread Robin Vickery
2008/8/12 VamVan [EMAIL PROTECTED]: 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

Re: [PHP] If Column Exists

2008-08-13 Thread VamVan
Interesting. Thanks guys!! On Wed, Aug 13, 2008 at 1:32 AM, Robin Vickery [EMAIL PROTECTED] wrote: 2008/8/12 VamVan [EMAIL PROTECTED]: 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

RE: [PHP] If Column Exists

2008-08-12 Thread Jay Blanchard
[snip] 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... [/snip] Use DESCRIBE TABLE; -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php