Re: --safe-updates and DELETEs

2008-12-06 Thread Waynn Lue
> > 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.

Re: --safe-updates and DELETEs

2008-12-06 Thread Martijn Tonies
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/mys

--safe-updates and DELETEs

2008-12-05 Thread Waynn Lue
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: INSERT INTO Test VALUES (1), (2); mysql> DELE