Re: Where UPDATE documentation?

2001-11-04 Thread Carl Troein 


Uriel Wittenberg writes:

 Carl, I appreciate your response, but I did check both the table of
 contents and the index. I did not do a string search on update, if
 that's what you had in mind.

I admit that the search function is as good as one might wish. And
I agree that finding things in the manual is not easy. There are
some things that are hard to find even if you know that they're
there, but I have no idea what to do about it.

 Multi-table updates and deletes are such fundamental features of SQL
 that it doesn't occur to new users like me that it could be unsupported.

Indeed. It'll be a big day for MySQL when 4.1 is released (and stable).
For now the only(?) workaround is to use locks, and that's horribly
ugly, inefficient, and much work to do.

 Maybe we're all foolish and lazy, but maybe also it'd be smarter if the
 relevant doc section mentioned the lack of support.

At least they could point out that the syntax given for a statement
or function is exhaustive, and possibly the manual could be better
at pointing out in what version different things were added (although
this is mainly useful for 3.x versus 4.x, since upgrading to the
latest stable version is something you're supposed to do anyway).

//C - has 60 mails to read now for some reason.

-- 
 Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
 Amiga user since '89, and damned proud of it too.


-
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

Where UPDATE documentation?

2001-11-02 Thread Uriel Wittenberg 

I am trying to do an UPDATE that is slightly less trivial than

UPDATE persondata SET age=age+1;

What I want is something like

UPDATE persondata SET age = select age from othertable where
persondata.id = othertable.id;

But the manual gives no clue as to whether this is possible. And if
there is a decent SQL reference somewhere on the web it is not easy to
find -- at least, not with the slow connection I have here in Beijing.
Could someone please help?

Thanks in advance,

Uriel



-
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