Talk:No user in rights window

Revision as of 11:26, 23 March 2007 by Tierlieb (talk | contribs) (added alternative)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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;