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:

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:

--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