RE: sql delete question

Hello Adolfo, Yes I have tried it too but it did not work. Anyway i have done it programatically in my app. Thanks. "Adolfo Bello" <[EMAIL PROTECTED]> wrote: >> I have two tables whose structures are below. >> >> - Table1 - >> table1id int not null auto_increment >> data varchar(30) >> >> - Ta

RE: sql delete question

> I have two tables whose structures are below. > > - Table1 - > table1id int not null auto_increment > data varchar(30) > > - Table2 - > table2id int not null auto_increment > table1id int not null > data varchar(30) > > > These two tables are connected to each other with the > "table1id" co

Re: sql delete question - solved

Hello Paul, I have tried the code you have written, before posting to list and it did not work. When I have seen the sentence "This requires that you have MySQL 4.x" at your mail I realized the problem. I am using mySQL 3.23.49. :( Thanks for your help. Paul DuBois <[EMAIL PROTECTED]> wrote:

Re: sql delete question

At 7:27 -0500 1/8/03, Veysel Harun Sahin wrote: Hello, I have two tables whose structures are below. - Table1 - table1id int not null auto_increment data varchar(30) - Table2 - table2id int not null auto_increment table1id int not null data varchar(30) These two tables are connected to each o

sql delete question

Hello, I have two tables whose structures are below. - Table1 - table1id int not null auto_increment data varchar(30) - Table2 - table2id int not null auto_increment table1id int not null data varchar(30) These two tables are connected to each other with the "table1id" column. I need to dele