XPerties Posted August 17, 2002 Share Posted August 17, 2002 This is what I get when I try to run the command. Of course I havent a clue if Im doing it right but the hack says to do this:add g_glow varchar(20) NOT NULL DEFAULT ""And this is what I get when trying: add g_glow varchar(20) NOT NULL DEFAULTMySQL said: You have an error in your SQL syntax near 'add g_glow varchar(20) NOT NULL DEFAULT' at line 1Any ideas?-Xperties Link to comment Share on other sites More sharing options...
fubar Posted September 7, 2002 Share Posted September 7, 2002 The command would be something like:ALTER TABLE 'database'.'table' ADD 'g_glow' VARCHAR(20) NOT NULL But if you're using phpMyAdmin you can do it using their forms. Like in the table properties find "Add new field :" and you should see a few drop down boxes next to it. Makes it easier if you're not familiar with the command structure. 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