From: Martijn Tonies
Date: December 6 2008 7:54pm
Subject: Re: --safe-updates and DELETEs
List-Archive: http://lists.mysql.com/mysql/215514
Message-Id: <002b01c957dc$63352a20$9c02a8c0@martijnws>
MIME-Version: 1.0
Content-Type: text/plain;
	format=flowed;
	charset="iso-8859-1";
	reply-type=original
Content-Transfer-Encoding: 7bit



> If I have a table like this:
> CREATE TABLE `Test` (
>  `TestId` bigint(20) default NULL
> ) ENGINE=MyISAM DEFAULT CHARSET=latin1
>
> Does using --safe-updates mean that it's impossible for me to ever delete
> from it, since it doesn't have a key?  For example:

http://dev.mysql.com/doc/refman/5.0/en/mysql-command-options.html#option_mysql_safe-updates

> INSERT INTO Test VALUES (1), (2);
> mysql> DELETE FROM Test WHERE TestId = 1;
> ERROR 1175 (HY000): You are using safe update mode and you tried to update 
> a
> table without a WHERE that uses a KEY column


With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com