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';
>
> [..]
no, you didn't, you just sw
Kevin Waterson wrote:
This one time, at band camp, Baron Schwartz <[EMAIL PROTECTED]> wrote:
I wish to select all bookmark_title and bookmark_url that have the same
keywords as
the bookmark_url 'http://www.redhat.com. I do this..
mysql> SELECT child.bookmark_id, child.bookmark_title, child.boo
This one time, at band camp, Baron Schwartz <[EMAIL PROTECTED]> wrote:
> > I wish to select all bookmark_title and bookmark_url that have the same
> > keywords as
> > the bookmark_url 'http://www.redhat.com. I do this..
> > mysql> SELECT child.bookmark_id, child.bookmark_title, child.bookmark_url
Baron Schwartz schrieb:
>> SELECT
>> child.bookmark_id,
>> child.bookmark_title,
>> child.bookmark_url
>> FROM
>> bookmarks AS child
>> WHERE
>> child.bookmark_keyword IN (
>> SELECT
>> parent.bookmark_keyword
>> FROM
>> bookmarks AS parent
>> WHERE
>> parent.bookma
Baron Schwartz schrieb:
> Hi Kevin,
>
> Kevin Waterson wrote:
>> I have a table of bookmarks that have keyword searching.
>> Fields
>>
>> +-+--+--+--+
>>
>> | bookmark_id | bookmark_title | bookmark_url |
>>
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 |
bookmark_
Kevin Waterson schrieb:
> I have a table of bookmarks that have keyword searching.
> Fields
>
> +-+--+--+--+
> | bookmark_id | bookmark_title | bookmark_url |
> bookmark_keyword |
> +-+--
Hi Kevin,
Kevin Waterson wrote:
I have a table of bookmarks that have keyword searching.
Fields
+-+--+--+--+
| bookmark_id | bookmark_title | bookmark_url |
bookmark_keyword |
+-+-
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 bookmark (Bookmark: A prope
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 property of
a Record
> 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 property of
a Recordset object or a form tha
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 Technical Writer
Ma
14 matches
Mail list logo
