Method A:
Delete from STORIES where story_id = '1'
Delete from STORIES where story_id = '3'
Delete from STORIES where story_id = '5'
or
Method B:
Delete from STORIES where story_id IN (1,3,5)...I guess this is the
same as using OR's
What is the state of the database if the deletion on story_id = '3' fails?
In method A, 1 and 5 are deleted.
in method B, is only 1 deleted? are 1 and 5 deleted, or are none of
them deleted (i.e. MySQl treats this as one unit of work)?
--
-James
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
