yes, sorry. my intention is to delete repeated rows from TABLE1. and since its a bit difficult with mysql the way that i take is create a new table TABLE2 with the repeated rows (but not repeated in TABLE2), and then i want to delete from TABLE1 all the rows which also are in TABLE2. later on, i INSERT again the values from TABLE2 to TABLE1.
i have mysql version 3.22 thanks On Tue, 14 Oct 2003, Director General: NEFACOMP wrote: > I think the question is not very clear. > Do you want to delete from all the tables or you just want to delete from > one of the tables? > Does your MySQL version support sub-queries? (Is it Ver 4.1.x ?) > > I saw some replies to your question, did they solve your problem? > I am asking this because a DELETE command is one of the most risky > operations on data. > > > Thanks > Emery > ----- Original Message ----- > From: <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Monday, October 13, 2003 17:25 > Subject: deleting rows which table1.row=table2.row > > > > how to delete rows which table1.field=table2.field -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
