How to create a table

[tonvaneck]

Hello MySql users,

Using the tool isql 1.0.3 we are trying to create a table with the next sql statement:

use test
create table NewTb (MyFld char(20) not null);

an error code 1064 is generated (a syntax error)

Can someone tell me what we do wrong?

Nice regards,

Ton.

 

[hos2]

perhaps because there is no primary key definend ??

create table NewTb (MyFld char(20) not null,PRIMARY KEY (MyFld));

 

[tonvaneck]

Hello hos2,

You gave the right information.

Nice regards,

Ton.