Re: where to get mySQL questions answered?

From: Five Cats (cats_spam_at_[127.0.0.1)
Date: 12/31/03 

Date: Wed, 31 Dec 2003 09:57:37 +0000

In message <pFoIb.874722$6C4.108878@pd7tw1no>, Randell D.
<reply.to.news.group.only@and.share.com> writes
>
>"Zaphod Beeblebrox" <foo@spamsnothere.org> wrote in message
>news:C41Ib.860092$6C4.759329@pd7tw1no...
<snip>
>
>Secondly... Remember Google keeps a good index of the newsgroups and I
>believe either with them, or with deja or dejavu or something that they give
>online access too - But in most cases, as long as its not porn, you should
>be able to ask your ISP to add mailing.database.mysql to their news feed -
>The additional traffic will not cost them but a fraction of a fraction of
>their overhead... I frequent the newgroup and find it useful with little if
>any junk email.
>
Thanks, have added that to my list of newsgroups.

>Lastly... If the problem you are facing is not the query length, then it
>might be worth while posting some of your code (if its not too long) in to
>this newsgroup as I am having second thoughts, thinking that since your
>query works with one word, but not two - and it seems that your code might
>be passing the syntax of the query wrongly (perhaps leaving your database
>hanging waiting for more info - dunno - its been a long time since I've had
>mysql on a win98 box)... Try echo'ing the full query to your web client
>browser and then copy/paste that to your mysql client and see what the
>result would be... and check error log files too!

I agree that the syntax is probably the problem, or possibly that a
query which will take a humongous time to execute is being created
(possibly a Cartesian product is being generated). However we don't
have the schema, or the nrows for each table, or what the final SQL
being run is so this is all a shot in the dark.

>
>Hope something above helps... best of luck... and happy new year,
>randell d.
>
> 

-- 
Five Cats
Email to: cats_spam at uk2 dot net

Relevant Pages

  • Re: where to get mySQL questions answered?
    ... In message, Randell D. ... >query works with one word, but not two - and it seems that your code might ... You say you don't have the schema - Do you mean you don't have the table's ... via the newsgroup, so everyone can learn... ...
    (comp.lang.php)
  • Re: How to specify the name of the database to export to in a make table query
    ... you could make your query in .net like this ... sqlCommand cmd = new SqlCommand; ... you can use added String to make the whole query like String1 + "Table ... Please reply to newsgroups only, ...
    (microsoft.public.access.queries)
  • Re: CIRCULAR REFERENCE CAUSED
    ... rare) you need to post to multiple newsgroups, ... I'm sure I could fix the query, ... open the query in SQL view and post the SQL code here (this one ...
    (microsoft.public.access.queries)
  • Re: HELP-cant open query recordset
    ... >I am having difficulty opening a query recordset for analysis. ... Dim prm As Parameter ... Dim rs As DAO.Recordset ... >I will post this to a couple of newsgroups because I'm not sure which one is ...
    (microsoft.public.access.queries)
  • Re: Word Mail Merge using Access database
    ... Use a select query in Access with the two tables linked on the relevant ... Please post any further questions or followup to the newsgroups for the ... Doug Robbins - Word MVP ...
    (microsoft.public.word.mailmerge.fields)