"Bamelis Steve" <[EMAIL PROTECTED]> wrote: > > I'm a newbie when it comes to mySQL. > > I have the following command. > > DELETE FROM tblTest2 > > USING tblTest2,tblTest > > WHERE tblTest.Name = tblTest2.Name > > AND tblTest.URL = tblTest2.URL > > AND tblTest.Comment = tblTest2.Comment > > I get the following error: > > You have an error in your SQL syntax near 'USING tblTest2,tblTest WHERE > tblTest.Name = tblTest2.Name AND tblTest.URL = tblT' at line 1 > > > I want to delete rows from tblTest2 where there are similarities in tblTest. > > In fact using a subselect or something.
What version of MySQL server do you use? The above DELETE syntax is supported from v4.0.2. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]