Error MySQL

[mico]

Hola

Me he animado a empezar con MySQL, al crear la siguiente tabla me sale un error:

Código:

mysql> create table sales-rep(
    -> employee-number INT,
    -> surname VARCHAR(40),
    -> first-name VARCHAR(30),
    -> comission TINYINT);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '-rep(

employee-number INT,
surname VARCHAR(40),
first-name VARCHAR(30),
comissio' at line 1

Sabeis por que?
Gracias.

[dalyla]

Porque no intentas poniendo un _ en vez de un -