Derleek Posted July 9, 2008 Share Posted July 9, 2008 How do i set up a table cell to have a default value so i don't have to 'INSERT' anything so i can just do 'UPDATE'. I tried doing CREATE TABLE options( nameToggle INT NOT NULL DEFAULT 0) Quote Link to comment Share on other sites More sharing options...
adam84 Posted July 9, 2008 Share Posted July 9, 2008 CREATE TABLE options( nameToggle INT DEFAULT 0), I think this is what you want, not 100% sure Quote Link to comment Share on other sites More sharing options...
Derleek Posted July 9, 2008 Author Share Posted July 9, 2008 no the 'UPDATE' command didn't work when i create a table with 'default 0' Quote Link to comment Share on other sites More sharing options...
adam84 Posted July 10, 2008 Share Posted July 10, 2008 what is your update command? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.