Talk:No user in rights window: Difference between revisions
From Open-Xchange
(added alternative) |
(No difference)
|
Revision as of 11:26, 23 March 2007
What about setting defaults for that instead of changing every occurence afterwards?
Without testing and some years past since I wrote mySQL, I'd recommend something like:
ALTER TABLE prg_contacts \ ALTER intfield02 SET DEFAULT = null, \ ALTER intfield03 SET DEFAULT = null, \ ALTER intfield04 SET DEFAULT = null, \ ALTER intfield05 SET DEFAULT = null, \ ALTER intfield06 SET DEFAULT = null, \ ALTER intfield07 SET DEFAULT = null, \ ALTER intfield08 SET DEFAULT = null;