Shelley Waltz wrote: <endless amounts of needless quoting removed> > OK, thanks ... > mysql> desc quotas_tracking; > +----------------+---------------------+------+-----+---------+-------+ > | Field | Type | Null | Key | Default | Extra | > +----------------+---------------------+------+-----+---------+-------+ > | QuotasLimitsID | bigint(20) unsigned | YES | MUL | NULL | | > | TrackKey | varchar(512) | YES | | NULL | | > | LastUpdate | bigint(20) unsigned | YES | MUL | NULL | | > | Counter | decimal(10,4) | YES | | NULL | | > +----------------+---------------------+------+-----+---------+-------+ > 4 rows in set (0.00 sec) > > > Does this say the counter is zero or NULL - which field is the counter - > Counter?
What that says is that all the columns are allowed to contain NULL, and that the default value is NULL - ie if an insert doesn't specify values for all columns, then the unspecified ones will be NULL, and NULL is accepted. NULL means "nothing stored" and is different from zero or an empty string. >My goal here is to have quotas(cumulative) for entire domain outgoing >and to monitor this for some time before instituting a limit. I have the >message count at 1800/hour and wish to view the counter in the database >or the log file so I can determine a realistic limit. > >I do not seem to be able to locate the value in the database so I can see >that my outbound policy is working and what the outgoing count is. Have you tried "select * from quotas_tracking ;" ? -- Simon Hobson Visit http://www.magpiesnestpublishing.co.uk/ for books by acclaimed author Gladys Hobson. Novels - poetry - short stories - ideal as Christmas stocking fillers. Some available as e-books. _______________________________________________ Users mailing list [email protected] http://lists.policyd.org/mailman/listinfo/users
