I'm having a little trouble with an UPDATE statement in MySQL 3.23.39 on
Mac OS 10.0. The statement is:
UPDATE book SET book_deleted = 'Y' WHERE book_id = '123';
This statement updates the column that I specified and another as well. A
timestamp(14) column is changed to today's date as well.
Here's what the table looks like:
CREATE TABLE `book` (
`book_id` int(10) unsigned NOT NULL default '0',
`event_id` int(10) unsigned NOT NULL default '0',
`book_deleted` enum('N','Y') NOT NULL default 'N',
`room` varchar(20) NOT NULL default '',
`start` timestamp(14) NOT NULL,
`end` timestamp(14) NOT NULL,
`attendance` int(3) default NULL,
`equip` char(1) NOT NULL default 'N',
`staff` char(1) NOT NULL default 'N',
`catering` char(1) NOT NULL default 'N',
`details` char(1) NOT NULL default 'N',
PRIMARY KEY (`book_id`),
UNIQUE KEY `book_id` (`book_id`),
KEY `event_id` (`event_id`)
) TYPE=MyISAM PACK_KEYS=1
After the UPDATE the value of book_deleted is 'Y' and the value of start is
changed to now(). Any ideas on why this is happening?
--
David Nagel
Director of Communications & Information Services
U of R Students' Union
Regina, SK, S4S 0A2
---------------------------------------------------------------------
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
