> Created a table which will be used to track/process URLs:
> CREATE TABLE dbURLlist(
> ID SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
> AGING TINYINT UNSIGNED ***** ,
> URL TINYTEXT NOT NULL,
> PRIMARY KEY (ID),
> INDEX (URL (25)))
>
> In a PHP script (also prototyped using MySQL-Front) I tried:
> UPDATE dbURLlist SET AGING=AGING+1
>
> When ***** was set to DEFAULT 1 every record updated to 2, as
> expected; whereas when ***** was set
> to NULL or DEFAULT 0, it refused to update any of the records present.
NULL: That is to be exptected. Undefined plus 1 is still
undefined.
0: Can't reproduce this on my box (v. 3.23.35). It's
being updated to 1 as it should be.
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
