I'll reformat the SQL with line breaks so it looks more readable to me.
On Tue, 11 Mar 2008, smriti Sebastian <[EMAIL PROTECTED]> wrote:
I created two tables like this:
create table customer(SID int,
name varchar(20),
primary key (SID));
create table
On Tue, Mar 11, 2008 at 1:51 AM, smriti Sebastian
<[EMAIL PROTECTED]> wrote:
> I created two tables like this:
> create table customer(SID int,name varchar(20),primary key(SID));
> create table orders(OID int,O_Date date,customer_SID int,primary
> key(OID),Foreign key(customer_SID) references cu
I created two tables like this:
create table customer(SID int,name varchar(20),primary key(SID));
create table orders(OID int,O_Date date,customer_SID int,primary
key(OID),Foreign key(customer_SID) references customer(SID) on delete
cascade on update cascade);
And inserted values into it.but when