MasterTobi Posted November 24, 2010 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
Aibo Posted November 24, 2010 Posted November 24, 2010 you dont need to use conditions when altering a table, because whole table is affected.
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