Baron Schwartz schrieb:
> You have one final problem, which isn't really causing you trouble with
> THIS query, but will likely bite you in the future: you are selecting
> non-grouped columns in a GROUP BY query.
SELECT DISTINCT will help too, of course (at least in similar cases) only if
require
Baron Schwartz schrieb:
> SELECT parent.bookmark_url as pbu, parent.bookmark_keyword as pbk
> FROM bookmarks AS child
>JOIN bookmarks AS parent
> ON parent.bookmark_keyword = child.bookmark_keyword
> WHERE child.bookmark_url='http://www.redhat.com';
>
>
bookmark_title, child.bookmark_url FROM
bookmarks AS child join bookmarks AS parent ON parent.bookmark_keyword =
child.bookmark_keyword WHERE child.bookmark_url='http://www.redhat.com' GROUP BY
child.bookmark_keyword;
That query is ri
hild.bookmark_id, child.bookmark_title, child.bookmark_url
> > FROM bookmarks AS child join bookmarks AS parent ON parent.bookmark_keyword
> > = child.bookmark_keyword WHERE child.bookmark_url='http://www.redhat.com'
> > GROUP BY child.book
Baron Schwartz schrieb:
>> SELECT
>> child.bookmark_id,
>> child.bookmark_title,
>> child.bookmark_url
>> FROM
>> bookmarks AS child
>> WHERE
>> child.bookmark_keyword IN (
>> SELECT
>> parent.
Baron Schwartz schrieb:
> Hi Kevin,
>
> Kevin Waterson wrote:
>> I have a table of bookmarks that have keyword searching.
>> Fields
>>
>> +-+--+--+--+
>>
>> | book
Hi Sebastian, Kevin,
Sebastian Mendel wrote:
Kevin Waterson schrieb:
I have a table of bookmarks that have keyword searching.
Fields
+-+--+--+--+
| bookmark_id | bookmark_title | bookmark_url
Kevin Waterson schrieb:
> I have a table of bookmarks that have keyword searching.
> Fields
>
> +-+--+--+--+
> | bookmark_id | bookmark_title | bookmark_url |
>
Hi Kevin,
Kevin Waterson wrote:
I have a table of bookmarks that have keyword searching.
Fields
+-+--+--+--+
| bookmark_id | bookmark_title | bookmark_url |
bookmark_keyword
I have a table of bookmarks that have keyword searching.
Fields
+-+--+--+--+
| bookmark_id | bookmark_title | bookmark_url |
bookmark_keyword
Scott Haneda <[EMAIL PROTECTED]> wrote:
> There are some things I do in mysql often, is there some way to alias or
> otherwise bookmark a a sql statement for simple rapid use in the future?
You can put SQL statements to the file and then execute them from the file.
--
For technical support con
There are some things I do in mysql often, is there some way to alias or
otherwise bookmark a a sql statement for simple rapid use in the future?
--
-
Scott HanedaTel: 415.898.2602
http://www.newgeo.com
l DuBois" <[EMAIL
PROTECTED]>
rs.com> cc: <[EMAIL PROTECTED]>
At 7:04 +0500 7/24/03, Shahid M. Syed wrote:
> At 8:45 +0500 7/23/03, Shahid M. Syed wrote:
>Hello
>
>Does any version (production or future) of mysql supports Bookmarks?
What is "Bookmark" capability in a database context?
You can use the Bookmark property to set a
Shahid M. Syed wrote:
At 8:45 +0500 7/23/03, Shahid M. Syed wrote:
Hello
Does any version (production or future) of mysql supports Bookmarks?
What is "Bookmark" capability in a database context?
You can use the Bookmark property to set a bookmark (Bookmark: A pro
> At 8:45 +0500 7/23/03, Shahid M. Syed wrote:
> >Hello
> >
> >Does any version (production or future) of mysql supports Bookmarks?
>
> What is "Bookmark" capability in a database context?
You can use the Bookmark property to set a bookmark (Bookmark: A pro
At 8:45 +0500 7/23/03, Shahid M. Syed wrote:
Hello
Does any version (production or future) of mysql supports Bookmarks?
What is "Bookmark" capability in a database context?
Regards
Shahid M. Syed
Karachi, Pakistan
http://members.tripod.com/shahid_syed
--
Paul DuBois, Senior Techni
Hello
Does any version (production or future) of mysql supports Bookmarks?
Regards
Shahid M. Syed
Karachi, Pakistan
http://members.tripod.com/shahid_syed
18 matches
Mail list logo