MrFish Posted January 30, 2013 Share Posted January 30, 2013 (edited) Semi-Solved I am trying to follow the MySQL site but I can't get this to work- IF EXISTS (SELECT * FROM information_table.COLUMNS WHERE TABLE_NAME='db_name' AND TABLE_NAME='communityCustomFeatures' AND COLUMN_NAME='ccf_id');BEGIN;ALTER TABLE `communityCustomFeatures` ADD `ccf_id` ) FIRST;ELSE;ALTER TABLE `communityCustomFeatures` MODIFY `ccf_id` ) FIRST;END IF; It turns up this error- ------------------ IF EXISTS ( SELECT * FROM information_table.COLUMNSWHERE TABLE_NAME = 'db_name'AND TABLE_NAME = 'communityCustomFeatures'AND COLUMN_NAME = 'ccf_id' ); MySQL said: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF EXISTS (SELECT * FROM information_table.COLUMNS WHERE TABLE_NAME='db_name' AN' at line 1 ------------------- I cannot figure out why. Edited January 30, 2013 by MrFish Link to comment Share on other sites More sharing options...
MrFish Posted January 30, 2013 Author Share Posted January 30, 2013 Looks like I need to create a mysql procedure to do this. I will just do something else in php instead. Link to comment Share on other sites More sharing options...
xhtmlchamps1 Posted January 30, 2013 Share Posted January 30, 2013 First step remove IF EXISTS and here is the actual code (SELECT * FROM information_table.COLUMNS WHERE TABLE_NAME='db_name' AND TABLE_NAME='communityCustomFeatures' AND COLUMN_NAME='ccf_id');BEGIN;ALTER TABLE `communityCustomFeatures` ADD `ccf_id` ) FIRST;ELSE;ALTER TABLE `communityCustomFeatures` MODIFY `ccf_id` ) FIRST; Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now