HeidiSql - keep getting error 1064

I keep getting the error which appears in the following picture when I try to make a new table:

Here is my code:

CREATE TABLE SalesKicker {
id INT(6) UNSIGNED AUTO_INCREMENT,
PRIMARY KEY(id),
BedrijfsName VARCHAR(30) NOT NULL,
ContPers VARCHAR(30) NOT NULL,
TelNum INT(20),
Plaats VARCHAR(30),
Land VARCHAR(30),
PostCode VARCHAR(30),
GebrDat TIMESTAMP
}

Can somebody tell me what I`m doing wrong here?

Answers


Use parenthesis, not curly braces. Also, do not forget the semi-colon at the end of your statement and put your key declarations at the end.

CREATE TABLE SalesKicker (
  id INT(6) UNSIGNED AUTO_INCREMENT,
  BedrijfsName VARCHAR(30) NOT NULL,
  ContPers VARCHAR(30) NOT NULL,
  TelNum INT(20),
  Plaats VARCHAR(30),
  Land VARCHAR(30),
  PostCode VARCHAR(30),
  GebrDat TIMESTAMP,
  PRIMARY KEY(id)
);

Need Your Help

Special simple random number generator

c++ c algorithm math

How to create a function, which on every call generates a random integer number? This number must be most random as possible (according to uniform distribution). It is only allowed to use one static

Compiling code only when it's needed

function math hash compilation metadata

I am making a program that compiles code from one language to another. e.g. codefile.lang1 => codefile.lang2