create TABLE

[Martin Fischer <fischer_(at)_refugees.net>]

Ich bitte hoeflich um ein create TABLE
Beispiel wg:


mysql> create TABLE news (
    -> email VARCHAR (35) NOT NULL, 
    -> KEY index_name (name(10));
ERROR 1064: parse error near '' at line 3
mysql> create TABLE news (
    -> email VARCHAR (35) NOT NULL,
    -> );
ERROR 1064: parse error near ')' at line 3
mysql> CREATE TABLE news (
    -> email VARCHAR (35) NOT NULL,
    -> PRIMARY KEY (email),
    -> ;
ERROR 1064: parse error near '' at line 3
mysql> select * from news;
Empty set (0.07 sec)

D A N K E