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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
