I have the following part in a schema
describe feeds
.........
........
| pubdate | timestamp | YES | | CURRENT_TIMESTAMP | |
show create table feeds;
`pubdate` timestamp NOT NULL default CURRENT_TIMESTAMP on update
CURRENT_TIMESTAMP,
when i make an
INSERT INTO feeds(...., pubdate) VALUES (....,NOW()+10000*RAND())
is there any chance to have:
mysql> select count(*) from feeds where pubdate = 0;
+----------+
| count(*) |
+----------+
| 593923 |
+----------+
1 row in set (5.90 sec)
mysql> select count(*) from feeds where pubdate > 0;
+----------+
| count(*) |
+----------+
| 287532 |
+----------+
1 row in set (5.33 sec)
--
Sometimes life hits you in the head with a brick.
Don't lose faith.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]