LibreOffice Error "1: Unexpected token: UNQUE in statement" -

i ran sql command

create table test(     key char(10) unique not null,      primary key(key) );

and gave me error:

2: unexpected token: unique in statement [create table test( key char(10) unique]

i'm trying create simple table sql command. error got, seems strange, because run on ms access.

anyway fix this?

//edit

due "key" restricted word in sql, gave try.

create table test(     mlp char(10) unique not null,      primary key(mlp) );

however, seems got broken again.

 5: unexpected token: unique in statement [create table test( mlp char(10) unique]

key reserved word in sql. choose name column , should work fine.

the official tutorial uses following syntax:

create table test(     mlp char(10) not null primary key );

Dil