Thanx Saurabh, and Pl. note that my name is 'Seshan' and not 'Sheshan'
I tried out all these alternatives. I know that primary key cannot contain null values
and It must be defined as not null. But, I found that my problem was some thing else.
I had installed MySQL as a part of default installation of mandrake
and both MySQL 3.20.x and 3.22.x were existing. I uninstalled both and downloaded ver
3.22.29 and now its working fine. Frankly, speaking I did not understand the whole
problem.
Anyway thanx once again.
Seshan.
Saurabh jadia wrote:
> Hi Sheshan,
> Well i have Mysql on Redhat6.1 and i found that if while defining primary key on a
>particular field if u do not specify 'Not Null' u get a syntax error. i executed this
>query on my database and it worked perfectly. the command i gave was ;
>
> create table test( id int(5) not null, matter text, primary key(id));
>
To subscribe / unsubscribe goto the site www.ilug-bom.org ., click on the mailing list
button and fill the appropriate information
and submit. For any other queries contact the ML maintener
