On Wed, Jan 23, 2002 at 11:25:31PM -0500, Jason Yates wrote: > Heres an example scenario, say I have two tables > > table1 > -----> id > | name > | > | table2 > |_____> id > address > zip > > I inner join table1 and table2 on id. I want to delete all the > records in table1 which have a zip of '90210'.
Good choice. 90210 is first to go on my list, too. :-) > I could create a script, run a select and loop through each id and > delete the records in table1. If you're running MySQL 4.x, multi-table deletes: http://www.mysql.com/doc/D/E/DELETE.html may be what you need, if I understand you right. Otherwise, you've gotta write that loop. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 22 days, processed 514,844,619 queries (266/sec. avg) --------------------------------------------------------------------- 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
