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) Link to comment https://forums.phpfreaks.com/topic/113952-default-values/ 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 Link to comment https://forums.phpfreaks.com/topic/113952-default-values/#findComment-585642 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' Link to comment https://forums.phpfreaks.com/topic/113952-default-values/#findComment-585915 Share on other sites More sharing options...
adam84 Posted July 10, 2008 Share Posted July 10, 2008 what is your update command? Link to comment https://forums.phpfreaks.com/topic/113952-default-values/#findComment-586452 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.