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
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
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
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
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
[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
6 matches
Mail list logo