@Igor: I thought that sql standard in this case doesn't guarantee that
> outer select will return rows in the same order that were enforced in
> inner select by "order by", does it?
>
> Pavel
>
> On Wed, Jun 10, 2009 at 11:15 AM, Rand Huck<randh...@gmail.com> w
Just out of curiosity, where in the syntax documentation does it mention
"selected from"?
On Wed, Jun 10, 2009 at 10:57 AM, Igor Tandetnik <itandet...@mvps.org>wrote:
> Rand Huck wrote:
> > In addition to what was already said, if you absolutely to omit the
> > '
In addition to what was already said, if you absolutely to omit the 'name'
from the final result set, you should be able to put the result of the union
in a temporary table.
CREATE TEMPORARY TABLE `tmp` (`id`, `url`, `selected`, `name`);
INSERT INTO `tmp` (
SELECT id, url, selected, name FROM
.
On Fri, Mar 13, 2009 at 9:12 PM, Igor Tandetnik <itandet...@mvps.org> wrote:
> "Rand Huck" <randh...@gmail.com> wrote in
> message
> news:d232e14b0903131800j53e59f56ic8e19b1d94bd7...@mail.gmail.com<news%3ad232e14b0903131800j53e59f56ic8e19b1d94bd7...@
Sorry, that was the result of my genericizing the code. The code I have does
not have the trailing comma.
On Fri, Mar 13, 2009 at 9:03 PM, Igor Tandetnik <itandet...@mvps.org> wrote:
> "Rand Huck" <randh...@gmail.com> wrote in
> message
> news:d232e14b09
I am refactoring a table for an Adobe AIR application a little bit and am
calling the following statements:
CREATE TEMPORARY TABLE `tbl_backup` (
`id` integer,
`title`varchar(255),
`body`text,
`status`varchar(16)
);
INSERT
6 matches
Mail list logo