Re: Problem Query EXISTS and IN

[EMAIL PROTECTED] wrote: Hi (Sorry by my english, i speak spanish) I have problem with a Query. It does not recognize EXISTS nor IN nor NOT IN My version is MySQL 4.0.11a-gamma But I do not know if it recognizes those clauses. I have dealed with the two forms: 1. SELECT usu_id FROM usuario

Problem Query EXISTS and IN

Hi (Sorry by my english, i speak spanish) I have problem with a Query. It does not recognize EXISTS nor IN nor NOT IN My version is MySQL 4.0.11a-gamma But I do not know if it recognizes those clauses. I have dealed with the two forms: 1. SELECT usu_id FROM usuario WHERE NOT EXISTS (SELECT

RE: Problem Query - Help Please

> When I execute the following query I get duplicate > product_id's as shown > below: > > SELECT * FROM product, product_category_xref, category WHERE > product_parent_id='' > AND product.product_id=product_category_xref.product_id > AND category.category_id=product_category_xref.category_id > AND

Problem Query - Help Please

When I execute the following query I get duplicate product_id's as shown below: SELECT * FROM product, product_category_xref, category WHERE product_parent_id='' AND product.product_id=product_category_xref.product_id AND category.category_id=product_category_xref.category_id AND product.product_p

Re: Problem query

Anish, Tuesday, August 13, 2002, 11:12:24 AM, you wrote: AM> problem AM> my sqlserver is not running AM> when i issue the command " mysql" AM> the response i got was " cant connect to local mysql AM> server through socket /var/lib/mysql.sock (111) " AM> when i issued the command " mysql.serve

Problem query

From Anish MAthew India Dear sir i am using Linux 7.2 as my OS and having mysql version 3.36. i am a novice learner of mysql though i am familiar with Oracle and sybase. when i got to no the GNU publice license and open source technology i thought of learning mysql. but i hav

Re: Mysql Problem Query

Also, see what errors you are getting in mysql .err file Regards, Bhavin. - Original Message - From: <[EMAIL PROTECTED]> To: "MySQL List" <[EMAIL PROTECTED]> Sent: Sunday, August 11, 2002 3:30 AM Subject: Re: Mysql Problem Query > did you also install the datab

Re: Mysql Problem Query

did you also install the databases that are part of the mysql installation? -Ll on 8/11/02 5:59 AM, Anish Mathew, typed: > my sqlserver is not running > > when i issue the command " mysql" > > the response i got was " cant connect to local mysql > server through socket /var/lib/mysql.sock (

Mysql Problem Query

From Anish MAthew India Dear sir i am using Linux 7.2 as my OS and having mysql version 3.36. i am a novice learner of mysql though i am familiar with Oracle and sybase. when i got to no the GNU publice license and open source technology i thought of learning mysql. but i hav