Whats wrong with this CREATE TABLE statement?

Question

CREATE TABLE findings (
  ident VARCHAR(28), 
  code VARCHAR(8), 
  when DATETIME, 
  ip VARCHAR(15)
);

Answer 1

The word when.

In some databases this is a keyword. So, while processing your create table instruction you may get some errors from your database management system.

Answer 2

when is a keyword in mysql and needs to be quoted with backticks:

CREATE TABLE `findings` (
    `ident` VARCHAR(28),
    `code` VARCHAR(8),
    `when` DATETIME,
    `ip` VARCHAR(15)
);

EDIT: It has been pointed out correctly in the comments, that this is not a good solution. You might be better off finding another name for your column.

Answer 3

if you are so keen on using when just prefix the column name with _.

Answer 4

BTW, is not a good idea to use reserved names for rows names, tables, etc.