mysql> CREATE TABLE bookmark (
-> bookmark_id INTEGER NOT NULL AUTO_INCREMENT,
-> bookmarkname VARCHAR (80) NOT NULL,
-> url VARCHAR (150) NOT NULL,
-> folder_id INTEGER NOT NULL,
-> last_scanned DATETIME DEFAULT NOW(),
-> last_notified DATETIME DEFAULT NOW(),
-> PRIMARY KEY (bookmark_id),
-> FOREIGN KEY (folder_id) REFERENCES folder(folder_id) ON DELETE CASCADE) TYPE = InnoDB;
No, not their default - you have to set the value when you insert or update the row. The default can only be a particular date, not a dynamic value.
e.g.
UPDATE bookmark SET last_scanned=NOW()
-Simon
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
