Hi,
Asaf Maruf wrote:
>
> How can i specify two columns together as primary key for a table.
>
> Using create table test
> (increment int , id int not null primary key, date not null primary key, name
>char(20) );
>
> doesn't work.
You should rather say
create table test (
increment int ,
Asaf Maruf wrote:
>
> Dear all on list
>
> How can i specify two columns together as primary key for a table.
>
> Using create table test
> (increment int , id int not null primary key, date not null primary key, name
>char(20) );
>
> doesn't work.
>
> Is it possible that one column is tex
Dear all on list
How can i specify two columns together as primary key for a table.
Using create table test
(increment int , id int not null primary key, date not null primary key, name char(20)
);
doesn't work.
Is it possible that one column is text and other is integer?
Help would be ap