[EMAIL PROTECTED] (Awarsd) writes:
> I have two databases.
> one with 4 tables and the other about 8 tables. and each table has the same
> userid.
> Instead of doing
> Delete from table1 where userid
> delete from tabl2
> detele fromt able3
> etc.... ##sorry for typoes.
Why not just fix them?
> is it possible to do it in one statment for each database
> Delete FROM table1,table2,table3,table4 WHERE userid = "userid";
> Any help is appreciated
Your question has nothing to do with DBI. This is a question about
SQL in general and the particualar SQL implementation you are using.
You may be able to use use foriegn key contraints with cascade delete
to delete all the related rows from tables in one database.
--
\\ ( )
. _\\__[oo
.__/ \\ /\@
. l___\\
# ll l\\
###LL LL\\
