Re: [mydns-users] MyDNS 0.9.5 status report + mydnsimport question

[<ja...@la...>]

Ok. ;-) Always looking for the easy way out, I guess! Thanks for all your=
 help=20
David!!

On Thursday 07 November 2002 08:27 pm, David Phillips wrote:
> ja...@la... writes:
> > ie, is there any way to do this in one sql statement? (this is from
> > memory of the table layout, forgive me if i get the column names
> > wrong.. )
>
> You can only delete from one table per query.  Hopefully, this will cha=
nge
> in 4.1 since it will have subselects.
>
> > also, is there a way to do this in one statement? (I think you alread=
y
> > answered this?)
> >
> > insert into soa (yada yada)..
> > get mysql_insert_id (12)
> > insert into rr (yada, yada, 12) ...
>
> No, you can only insert into one table per query.  I don't think even
> subselects will fix this.  It is simply how SQL works.  You can use use=
r
> variables to do that without hard coding the ID in the RR insert query.=
=20
> See my previous post for an example.
>
> Simon Dick claims this doesn't work with replication in version 3.  The
> manual states that "Update queries that use user variables are not
> replication-safe (yet)."  Either this includes inserts or it is a bug.
> However, you usually don't need variables if you are generating queries
> manually or through code.  But this would be a problem for mydnsimport.