thanks all, I'll do it with a perl script!
Dario
2007/11/14, Ravi Kumar. <[EMAIL PROTECTED]>:
> Try this (I do not have 4.0.24 to try):
>
> delete table1.* from table1, table2 where table1.id = table2.id and
> date
> Ravi.
>
>
> On 11/13/07, mark addison <[EMAIL PROTECTED]> wrote:
> >
> > Dar
Try this (I do not have 4.0.24 to try):
delete table1.* from table1, table2 where table1.id = table2.id and
date wrote:
>
> Dario Hernan wrote:
> > Hi all I need to delete some fields from a table but in the where
> > clause I need to put a select command.
> > For instance, delete from table1
Dario Hernan wrote:
Hi all I need to delete some fields from a table but in the where
clause I need to put a select command.
For instance, delete from table1 where id=(select id from table2 where
date
Not until 4.1. What you can do instead is run the select into a temp
table and then run the d
Hi all I need to delete some fields from a table but in the where
clause I need to put a select command.
For instance, delete from table1 where id=(select id from table2 where
datehttp://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]