Andrew,
Friday, April 26, 2002, 3:12:25 AM, you wrote:
AW> Hello, I am new to mysql - past the very basics - you may see a few silly
AW> questions - here is the first.
AW> I have a DELETE statement:
AW> delete bond_master,bond_data from bond_data where
AW> bond_master.cusip=bond_data.cusip and bond_master.maturity <= "2002/02/15";
AW> That has syntax errors. I am issuing this at the mysql command prompt - a
AW> little background:
AW> two tables:
AW> bond_master (fields: cusip, maturity, rating)
AW> bond_data (field: cusip, date, delta)
AW> common field:
AW> cusip
AW> goal:
AW> to delete all the records in the bond_data table where the maturity date
AW> is before a certain date
AW> so I tried the above select to no avail in many different combinations.
It's a common question.
Since v4.0 MySQL supports multi-table deletes:
http://www.mysql.com/doc/D/E/DELETE.html
If you use 3.23.X, you can find solution of your problem in the manual:
http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html
AW> Any help would be appreciated.
AW> Thanks,
AW> Andrew
--
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ 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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
