>>>>> "Mark" == Mark Papadakis <markp@stripped> writes:
Mark> Could something like this be possible in any way?
Mark> delete from table1,table2 where table2.id=table1.pid and table1.alfa=5;
Mark> Basically, I want to delete rows from table1 but now I have to
Mark> select table1.pid from table1, table2 where table2.id=table1.pid and
Mark> dbresult = mysql_store_result(&mysql);
Mark> dbrow = mysql_fetch_row(dbresult);
Mark> .. delete from table1 where pid=dbrow; ( Remove one entry
Mark> at a time .. )
Mark> dbrow = mysql_fetch_row( dbresult );
Mark> mysql_free_result( dbresult );
It would take about 8 hours to hack MySQL to do the above
(It's really a pitty that one needs to sleep, isn't it :)
Seriously; I had hoped to get this into 3.23.2, but it seems that it
must wait until a later 3.23 release due to lack of time.