MasterTobi Posted November 24, 2010 Share Posted November 24, 2010 hey @ all my Problem is when i add a column to my dadabase, the ******* error is coming Database query failed near "WHERE: " syntax error -.- executeSQLQuery( "ALTER TABLE ADD COLUMN (size) DEFAULT " ) sql.Query( "ALTER TABLE Playercars ADD COLUMN 'bla TEXT' DEFAULT 'none' WHERE Carid = ?", carid ); where is the problem ? pls need help Link to comment
Aibo Posted November 24, 2010 Share Posted November 24, 2010 you dont need to use conditions when altering a table, because whole table is affected. Link to comment
MasterTobi Posted November 25, 2010 Author Share Posted November 25, 2010 ah ok hehe thx Link to comment
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