> > 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 >
Yeah, that's the documentation I was looking at for my question. It says "You are not allowed to execute an UPDATE<http://dev.mysql.com/doc/refman/5.0/en/update.html>or DELETE <http://dev.mysql.com/doc/refman/5.0/en/delete.html> statement unless you specify a key constraint in the WHERE clause or provide a LIMIT clause (or both)." Since there's no key on this table, does that mean it's impossible unless I turn it off? Thanks for any help! Waynn