title: MySQL bug in the DELETE clause
body: <p>Has anyone experienced a situation like this?</p>
  <p>I accidentally typed the DELETE command in the wrong syntax (MySQL version 8.0.22). The command should never have worked, but it not only worked, it also deleted all data from the table:</p>
  <p><em><strong>Syntax: DELETE FROM test WHERE 123456;</strong></em></p>
  <p>Note that neither the column name nor the conditional operator was specified, but even so the command was executed without errors and deleted all data from the table.</p>
  <p>The code 123456 is an example but can be any code.</p>
  <p>Test it on any version of MySQL:</p>
  <pre><code>CREATE TABLE `test` (
    `cod` int NOT NULL AUTO_INCREMENT,
    `name` varchar(50),
    PRIMARY KEY (`cod`),
    KEY `ix_tmp_autoinc` (`cod`)
  );
  
  INSERT INTO `test`
  (`name`)
  VALUES
  ('MySQL bug');
  
  INSERT INTO `test`
  (`name`)
  VALUES
  ('MySQL bug 2');
  
  DELETE FROM test WHERE 123456;
  
  SELECT COUNT(*) FROM test;
  </code></pre>