Re: Delete in one table with information from another table

[Sinisa Milivojevic <sinisa@xxxxxxxxx>]

Johan Nilsson writes:
> Is there any way I can delete in one table with information from another
> table without doing as the following example?
> 
> SELECT column_name FROM table_1
> "result = 1,2,3"
> DELETE FROM table_2 WHERE column_name = 1
> DELETE FROM table_2 WHERE column_name = 2
> DELETE FROM table_2 WHERE column_name = 3
> 
> Regards,
> Johan Nilsson
> Software Developer
> BeCon Mobile Internet AB, Sweden
> E-Mail: johan.nilsson@xxxxxxxxxxxxxxx
> Web: http://www.beconmobile.com


Until 4.0 comes out, you will have to do it from your program. 

Regards,
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Mr. Sinisa Milivojevic <sinisa@xxxxxxxxx>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, FullTime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
       <___/   www.mysql.com

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread77911@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php